Null fields

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

Guest

I created a database and need to query a yes/no field . when I run the query
I only receive the ones that were checked as yes. I tried running a couple
different null queries such as is null, <>,"" and I can't get any results to
appear. Any suggestions? However,this only happens within certain tables.
I can run the same query against other tables and get results.

Thanks,
JSpotti
 
The 2 values you can use as criteria under a Yes/No field are True or False.
(That's some equivant values that will work also, such as -1 and 0.)

A Yes/No field in an Access table cannot be Null. If your query has multiple
tables and uses outer joins, you can end up with Nulls in the yes/no column,
but Access doesn't cope with this very well. Here's more info about that
problem:
Why I stopped using Yes/No fields
at:
http://allenbrowne.com/NoYesNo.html
 
Back
Top