is not null v.2000 not working help!

  • Thread starter Thread starter J
  • Start date Start date
J

J

Hi, I've been using is not null criteria in access 2000.
Bit its not working:is sorting records with and without data.

I was told access 2000 has a bug and to try <>"" instead,
however this is rejected as a data type mismatched criteria
expression.

Any ideas please! N.B I'm new to access and don't use coding.
The field info I want to sort in a query is stored in a
tick box and is a yes/no text type.

Thanks In anticipation,
J
 
Hi,


You have the SQL text produced by your query (cut and paste from the SQL
view) ? In theory it should work fine if you have something like:


WHERE ( Not fieldName1 Is Null ) AND ( Not FieldName2 Is
Null )

as example, to not keep records where fieldname1 or fieldname2 have a Null
value.


Hoping it may help,
Vanderghast, Access MVP
 
If the "field" is a tickbox then it is a boolean field and will always have a
value of Yes (True,-1) or No (False, 0). That means it will never be null. So
using "is Not Null" against that field will always return all records.

If you want all records where the tickbox is not checked then use criteria of
"False" (without the quotation marks).
 
Back
Top