Odd behaviour

[R C Nesbit]

I have a bit of code in a routine which iterates through a
For I = 0 to n loop
and builds and executes a number of SQL statements for a
MySQL database.

This bit:
sSql = "SELECT Sum(tblQuotes.TotalValue) AS SumOfTotalValue
From tblQuotes " & _
" INNER JOIN tblInvoice ON tblQuotes.InvoiceID =
tblInvoice.I_ID " & _

works once, then bounces to the error handler because it
produces:

"SELECT Sum(tblQuotes.TotalValue) AS SumOfTotalValue From
tblQuotesINNER JOIN tblInvoice"
^^^^^^^^^^^

If I put a break point in and step the code back to the sql
build line again it works fine
"SELECT Sum(tblQuotes.TotalValue) AS SumOfTotalValue From
tblQuotes INNER JOIN tblInvoice"
^^^^^^^^
I am wearing a dent in the desk banging my head against it!

[R C Nesbit]

Post by R C Nesbit
I am wearing a dent in the desk banging my head against it!

Bad form etc.. but please ignore this post.
As usual, just writing about it clears the brain-block.