Yes/No - Display only where checkbox is unchecked

resolva

Registered User.
Local time
Today, 07:13
Joined
Apr 7, 2009
Messages
35
I have made a query, within the query it has "HasPaid" which is taken from a checkbox.

Which critiera would I use to display only the results where the checkbox isnt checked?
 
These all work too:
Where [fieldname] = True
Where [fieldname] <> False
Where [fieldname] = Yes
Where [fieldname] <> No

Where [fieldname] = False
Where [fieldname] <> True
Where [fieldname] = No
Where [fieldname] <>Yes


Where [fieldname]
The last one works for true in sql because it resolves to True or False just like the other expressions.
In the design Access 2007 displays it as:
Where [fieldname] <> False
But it leaves the sql unchanged.
 

Users who are viewing this thread

Back
Top Bottom