Query parameter

[Guest]

I have a very simple access database. I am designing a query using 2 tables
- item list and item class. Each item in the item list has one item class
associated with it. There are 10 possible item classes.When running this
report,
I want to establish an item class paramter. I can do this easily if I want
to be able to choose only one item class as a parameter or even choose them
all. However, what if I want to choose 4 of the 10. How can I write a
parameter that actually has a lookup of the item class table and allows me to
choose any number of item classes that I want?

 

[Alex Ivanov]

Use IN clause in your criteria expression, like
SELECT * FROM .....
WHERE ItemClass IN(1,2,5,10)