Parameter Query with several values

[Zalina]

Dear friends,

could you please tell me how to allow users to query several entries from a table based on ID?

What I have.
For the field "ID" the criteria is [Enter ID], i.e. when the query is run, it askes for the ID and shows the entry with this ID.


What I want.
To be able to specify IDs that I want to pull out a table, i.e. to print out not one, but 2 or 3 entries based on their ID.

How can I do it?

Thank you very much for your help in advance!

Zalina

[Bob Fitz]

When you enter the ID numbers, try using "OR". For example:
22 OR 33 OR 41

[lfpm062010]

You can't use "OR", "AND", "IN", ...etc in the query parameter method. I tried and it did not work. If you have 3 ID then you have to use 3 [Enter ID] parameters. Example, [Enter ID 1] OR [Enter ID 2] OR [Enter ID 3].

There are other ways, but it will require to build form and vba code.

[orange]

Please show readers the SQL view of your query.