Use of Criteria in Access Query

Question

Hello,

I am creating a query where the are (26) items I would like to include in the query criteria (there are 143 different choices). At this point, I have been unable to select the appropriate records using my query. Is there a better way to accomplish the criteria selection?

Answer 1

One option is to store the criteria choices in a table and then join that table in your query.