Query Criteria

[Guest]

I created a query from 2 tables. The 2 tables have the same question but one is a drop down menu of 'yes', 'no', and 'n/a'. The other table is a comments section that you can write in if the question has an answer of 'no'. I created the query in design view and they all have the same link. I wanted to place in the criteria "No" so when there is a "No" answer that is the only thing that is counted. When I did that, the query does not show any of the "No" values.

What am I doing wrong

Thank you
dan

 

[John Spencer (MVP)]

As a guess, your drop down menu is hiding the real values that are being stored
in the table.

The real values may be numbers such as 1, 2, and 3.

You will have to determine what the real values are if you want to apply
criteria against the field. I would try adding a field to your query that uses
the CStr conversion function to force the value to appear.

SELECT CStr(DropDownField), DropDownField
FROM YourTable

That will tell you what the equivalent values are (although, it won't tell you
the field type).