Simple Select Query

[Plee]

I've been trying to select only the records that have a "yes" for a field. The form that users input into has a combo box for that field, and that field in the underlying table is a lookup to an unrelated table containing ID and field name. There are three values: yes, no, unknown.

For some reason when I run a select query for only the yes values, I also get the no values as well. The query looks something like this (dummy names for security purposes):

SELECT tblTheTable.*
FROM tblTheTable
WHERE tblTheTable.TheField = Yes;



Where am I going wrong?

I have lots of other questions for advanced access developers that have the time for my questions... Thanks!

[orange]

Where is the unrelated lookup table and field in your query?
Is the field a text data type? If so , you may need "yes".
But if you are querying a field in a different table, with a value from
tblTheTable, you'll have to have someway to identify the "different" table.

[Plee]

The table and fields are in the same database as the table with all the contacts. The field is a text type and I am getting the correct records from the query. However, I am also getting the wrong records (one's with "no" in the field).