including quotation marks in .sql string within vba?

[misubud]

I have need to run a vba .sql query.
standard querys are ok, but anything like the below example, falls over, I presume due to the fact that the .sql
contains a null value i.e a "", and hence the app doesn't know when the.sql string has finished.
How do you include quotation marks("") within a text string?

strSQL = "SELECT transaction_num, po_num, po_date FROM blah where po_num =""

 

[SkipVought]

Hi,

Are you sure that you don't mean...

strSQL = "SELECT transaction_num, po_num, po_date  FROM blah where po_num ='' "

???

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi misubud,

If you want an empty string, then do as Skip says, but if you are really dealing with Nulls then you don't want quotes at all, but something like ..

[blue]strSQL = "SELECT transaction_num, po_num, po_date  FROM blah where IsNull(po_num)"[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.