query, when prompted for id number how can i have more than one id number?

[Nuce007]

anyone know how to search for multiple items in an access query? I have it so you type in a id number between to get information on that id number, but I need to enter more than one number at a time. I have used a
=[Please enter ID number?]
in access but how can i enter more that one number at one time to include say 10 and 18 instead of just 10 or 18.

thanks!

[Akuma]

in the criteria line you can enter something like the following

=[id#1] Or =[id#2] Or =[id#3] etc.....

This is creating multiple values for the query to test on and will promp the user for each undeclaired variable. Give it a shot!

[Nuce007]

in the criteria line you can enter something like the following

=[id#1] Or =[id#2] Or =[id#3] etc.....

This is creating multiple values for the query to test on and will promp the user for each undeclaired variable. Give it a shot!

that did it ! thanks