SQL Error

  • Thread starter Thread starter PC User
  • Start date Start date
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
 
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.
 
I'm not sure how to troubleshoot, because the program halts on the
error with a highlight over the @.
Thanks,
PC
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL in VBA 8
SQL VBA -- INNER JOIN Syntax 6
insert into syntax error 4
Form's new SQL recordsource returns nothing 5
Can I Build an Access Statement (in 2007) as a String and Execute 3
ListBox as criteria for query 6
dlookup and dao.recordset 4
Double quotes within a variable string 2

Back
Top