SQL syntax for Filtering a report

[Neil Crawford]

Dear all,

Can you advise me of the correct syntax I should be using
in my variable strSQL please.

I'm using Docmd.OpenReport "ReportName", acPreview,,strSQL
to open a report using the SQL statement strSQL.

So far I've written as follows;-

strSQl = "[Firstpartpostcode] = '" & "BH1" & "'"

This works but I can't add another value to the string
and get it to work i.e. Or BH2. I can't find any guidance
in my books - they all seem to stop at one value!

thanks,

neil

 

[Duane Hookom]

There are several methods:
strSQl = "[Firstpartpostcode] IN ('BH1',BH2')"
or
strSQl = "[Firstpartpostcode] = 'BH1' or [FirstPartPostCode] = 'BH2'"

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting

 

[Guest]

Thanks, that worked,

Neil

-----Original Message-----
I am from the Access support department at

http://www.enterpriseprojectconsulting.com and we would
be happy to assist you in resolving your issue.

 

[Allen Browne]

So Neil, you are the spammer who is blocking people getting genuine answers
by posting endless, annoying, mindless, boilerplate responses so it looks as
if the person has an answer, when in fact they received nothing but an ad?

 

[Duane Hookom]

I assume Neil just replied to the wrong message. I hope the free advice
helped.