Help Filtering Query using Criteria (1 Viewer)

[cjp13]

I am trying to use a Query to filter a column that has been filled out using a Drop down Look up Table.

The Drop down list has 3 objects, APPLE, ORANGE, GRAPE.

The Query has 120 entries. There are 40 APPLE 30 ORANGE, 50 GRAPE etc.

When I made the Criteria I tried using the expression ="ORANGE"

This gave me a "criteria mismatch" . I had to USE the ORANGE ID NUMBER which is 2 in order to get Criteria to filter the Query.

=2 WORKED

=ORANGE DID NOT WORK

IS there anyway to be able to use =ORANGE, to filter?

 

[Tanya]

It sounds like you need to add the related table to your query and then group by the related table and then sort by your criteria.
Hope this makes sense.
Tanya