multiple lookup

[bharnett]

Is there any easy way (without a append/delete table) to have a query that can have multiple inputs for a query field. I shall exlpain: I have a query that pulls trade details based on a deal number. I would like it to be able to have the capacity to enter 4,5,6, etc... deal numbers and return only those details for the 6 trades. Anyway I can do that easily? Thanks, you guys are the best

 

[Norie]

Just add each value to a seperate criteria row.

Or use something like this

Between 4 And 6

Or this

In (4,5,6)

These should work unless I'm missing something.