Query "Enter Parameter" Multiple Items

[LB79]

Hi All,

This may be something quite basic... or not.

I have a query in which I am asking for a parameter to be entered. Works fine! My question is how do I enter multiple items ("Item1" or "Item2")?

Many thanks

 

[Brianwarnock]

If you have multiple parameters you will get multiple prompts.

Brian

 

[John Big Booty]

Put the following in the Criteria row of your Query;

[Item1] Or [Item2]

Although I would tend to do this using a form, and base the query on the form. You could use two Combo boxes, thus ensuring that your user entered two valid items.