Use of Criteria in Access Query

Flinn, Randal J 281 Reputation points
2021-04-30T12:18:01.747+00:00

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?

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 2,301 Reputation points
    2021-05-01T15:16:33.37+00:00

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

    0 comments