Criteria question about Access Query Designer

[ChrisOjeda]

I currently have an IN statement as the criteria for my query. The IN statement contains codes that a user enters into a table via a form (not a techinical person). The problem with the IN statement is that the user would like to have it always include all the codes that they have entered into the table that I mentioned.

What can I place in the criteria so that the IN statement will always be constructed to include all of the codes? If somebody has experience doing something like this or ideas, I'd appreciate them....

 

[KenReay]

Hi

IN (SELECT thecode FROM MyTable)

should do it, using the appropriate column and table names of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK