sql in VBA code

[ice051505]

Hi all, just quick question

this is my sql on VBA code

Sql1 ="Select [SmallArea] From [AreaQuery1] WHERE [SmallArea]="NA";"

I try to find any record in SmallArea that contain "NA", it give me the compile error of "expected: end of statement"

Can anyone fix it for me? Thanks!​

 

[jdraw]

Try

Sql1 ="Select [SmallArea] From [AreaQuery1] WHERE [SmallArea]=[COLOR="Red"][B]'[/B][/COLOR]NA[COLOR="Red"][B]'[/B][/COLOR];"

 

[ice051505]

Got it! Thank you!

Try

Sql1 ="Select [SmallArea] From [AreaQuery1] WHERE [SmallArea]=[COLOR=red][B]'[/B][/COLOR]NA[COLOR=red][B]'[/B][/COLOR];"