If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

|Im sure sinndho has got it right
but the easy way to resolve this issues is to actuallyu look at the value of the variable strSQL NOT the VBA that create the SQL
so set a break point (ie use the debugger, if you dont' knwo how to tuse the debugger [or worse yet dont' know what the debugger is / does] then know whould be a good time to learn) or at the very least display the value of strSQL in a message box)