build querry prompt to return list?

[beancounter]

Hi all,

I am trying to build a querry prompt that will let me enter a string of record numbers and return those record numbers once run. For example: I have a large database and know (or can find) the record numbers but want to enter ten of them out of order in a single querry and get only those.

How do I do that?

 

[Russell Hauf]

Short answer: you can't. But what you could do is to create a table where you enter numbers (one per record, or row), then join that table to the table you are querying.

Hope this helps,

Russell