By item in list box (1 Viewer)

[pumog]

Hi

Is it possible to set up a query that selects all records that correspond to a sub-category in a list box? For example a database that has 3 sub-categories of people within a list box in one field, and I want to select all the people that are within one of those sub-categories. I suspect not, but would very much welcome any suggestions. Thanks

 

[David R]

You'll have to include a field in the query that you can set criteria on. For instance, if this subcategory is stored in a lookup table, and the ID stored in the main table links to that lookup table, then include the lookup table in your query and set the Criteria for that field to be the subcategory you want to view.

Is that what you were asking? Post back if I've misunderstood the question.