Not equal to

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?
 
A

Allen Browne

Try:
Is Null Or <> 0

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