Need help with a query displaying a "No" in one or more fields.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One job of a database I am building is to track if "Incoming Folks" have been
"Phoned" or "Mailed". These two things are tracked in two different fields
in the same table using "Yes/No" Combo Box. I would like to have a query
that will provide a list of all folks with a 'No' in either box.

I have tried putting 'No' under the "Or" row in the query, but that only
shows folks with "No" in both fields.

Any help is greatly appreciated.
Thanks
Howemd
 
From your description, it sounds like you've tried putting No under both
fields, in two separate criterion rows. If you'll copy the SQL statement of
your query and post it back, the 'group may be able to parse out what seems
to be happening...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Try putting a No in the first OR row of the Phoned field, then another No in
the second OR row of the Mailed field.
 
This is what I am currently using, but if you change "Phoned" to Yes, then it
will not show the NO in "Mailed".
 
Do you have on the first OR row a NO for Phoned and a blank for Mailed?
Do you have on the second OR row a blank for Phoned and a NO for Mailed?
If you do, then I'm stumped, but from your results it sounds like you have
two NOs in the same OR row.
 
Back
Top