Use ( instead of "<<>><<URGENT<<>>><&gt

[bitech]

I am trying to write an SQl statement in my Access Module. I can't use the " where they belong, is there a way I can use ( instead?

My SQL statement Reads:

DoCmd.RunSQL"UPDATE [Quarterly Report] SET [Quarterly Report].Jan = DSum("[Jan]",'Quarterly Report',"

='Number of New Corporate Members'&quot
WHERE ((([Quarterly Report].Category)="Total&quot);"

This code works when I use it in a query, but when I try to use it in the Module I get an error.​

 

[jhall156]

If you have to use the DoCmd object...
After the first double quote and before the last double quote, wherever you need a double quote use & CHR(34) &

you might have to create a sqlstring variable first

also


you probably would be better of to use a SELECT SUM(field) FROM table instead of the DSUM
JHall