OpenReport and valid SQL WHERE clause

Randix

Registered User.
Local time
Today, 20:28
Joined
Mar 24, 2001
Messages
56
I want to use the OpenReport command in conjunction with a wherecondition that contains multiple variables. I realize you don't use the word "WHERE", but I can't come up with the right expression. For example, if i want to include records where x=12 and x=35, how would i include it?

svar2 = ????????????
DoCmd.OpenReport svar1, acViewPreview, , svar2

if i'm not clear, i want it to run a report that includes 2 records--one where x=12 and one where x=35

[This message has been edited by Randix (edited 07-02-2001).]
 

Users who are viewing this thread

Back
Top Bottom