Sorting out a Yes from a toggle field

[Janmck]

I have a query that has a "yes" or "No" toggle field and I want my query to
not include the yeses so I can mail only to the no's. I have tried putting
<>Yes in the Query and tried typing in NO.


I have searched and read and cannot find an answer to what I know must be
very simple and basic. Please help!
JanMck

 

[Jeanette Cunningham]

Hi Janmck,
use True for yes and False for No.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[John Spencer MVP]

What is the type of field that the Toggle Control Frame is attached to? Is it
a Yes/No (boolean) field or is it a number field? Usually toggle fields will
return a number from 1 to n. So I suspect that you need to use either 1 or 2
as the value you should be looking for to filter the records.

Try entering = 2 as the criteria and see if you get the correct records. If
not, try entering <> 2 (or enter 1 if you prefer) and see if that gives you
the correct records.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County