using dbs.CreateQueryDef with multiple criteria

[Wrathchild]

Hi, I'm creating a query on the fly in code and I'm stuck on how to put multiple criteria on a field. I'm asking for field results of "BA" or "BB" but everything I've tried it just returns "BA or BB" as the criteria, which of course won't work. How do I separate them?

 

[CharlesCook]

Try something like this:


Tick = Chr(34)

x = Tick + "BA" + Tick + " or " + Tick + "BB" + Tick

MsgBox x

CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining

 

[Wrathchild]

thanks! that did it; I was so close - I was using quote = """" instead of tick...guess I had one too many "