Query on field with multiple criteria

I have a table with a field that is a lookup to a table listing possible categories in which I can place a student.  I'd like to perform a query that includes all records for which a certain category ("Silver Creek") is selected.  The field type is number and has this under the lookup:

SELECT [T_Category].[ID], [T_Category].[Category] FROM T_Category ORDER BY [Category];

The bound column is 1 (the index/unique ID) and the column count is 2.

Any help is greatly appreciated.
BBluAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
You should add table with categories to your query. Look at sample
DBcats.accdb
0
 
BBluAuthor Commented:
Thanks, Ace. I see that you have a relationsip set up as one (Category) to many (students).  If a student can be in more than one category, just that change things?
0
 
BBluAuthor Commented:
Got it!  That worked, Ace! Thanks.
0
 
BBluAuthor Commented:
Thanks, Ace!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.