Mulitple number look up

[Tcurtis]

Is there a way to look up multiple numbers in Access?
I have a database and can input one number and have it return the information I need but is there a way to put in several numbers at once and pull the data?


Thanks

 

[Joe4]

Create a table that stores one number per record. Then do a matched query between this table and your other table based on the field you are looking up.

 

[Micron]

Maybe all you need is an IN clause in your query criteria for the field: IN(2,4,6,7,9...)
You don't say if the criteria will be hard coded into the query or if you are using a form; i.e. can input one number , but into what?