multiple store numbers

[Guest]

i am wanting to be able to pull multiple records based on a store number. i
have 6 stores each with a different number. I can currently pull the
information based on a beginning and ending date, which i want to continue
doing but right now i can only request the info per one store....i want to be
able to compare two or three of the stores at one time. so i am not sure
what to put into the criteria.
Please help

 

[Guest]

Open the query in design view and put the second store number on a new row in
the grid. If you are using date criteria then repeat the criteria in the
second row also.

Alternate way is to put the second, third store number in the criteria row
like this --
34 Or 35 Or 65