Not equal to

  • Thread starter Thread starter iiimriii
  • Start date Start date
I

iiimriii

I have made a Query in the desing view I am trying to set a Criteria so
that information in the field "NOTE" will only list data if it is not
0.

what should I put to the criteria?
 
Try:
Is Null Or <> 0

If it is a text type field, you need quotes around the zero:
Is Null Or <> "0"
 
Back
Top