Re: Invalid SQL Statement

SueB wrote:

Bob,

Bummers! It didn't work. I changed IFF to IIF and also changed the
"as" to AS (in that IIF clause). Still the same error ... upon entry
into the MailMerge function, the passed argument of strSQL (a string
variable with that ugly long SQL statement) is detected as an error.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

Do a
Debug.Print strSQL
or whatever the variable name is before passing it to the routine. Then create a new query and go to View/SQL in the querybuilder and copy/paste the SQL statement and attempt to run. It will probably show you the errors of your ways.
.