SQL Error

P

PC User

I get an error on this statement at the "@" symbol. How can I correct
it?
strSQL = strSQL & "[tsubPermissionList]![LastName] & "@mwdh2o.com" AS
EmailAddress, "

Thanks,
PC
 
D

Dan Artuso

Hi,
Not clear what you are trying to concatenate but, you have an extra double quote in there
strSQL = strSQL & [tsubPermissionList]![LastName] & "@mwdh2o.com" AS EmailAddress

and don't forget to Debug.Print strSql
to troubleshoot.
 
P

PC User

I'm not sure how to troubleshoot, because the program halts on the
error with a highlight over the @.
Thanks,
PC
 
Top