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).]
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).]