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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Making a macro only work on certain files 2
Page numbering with Merged Document and IF statements 1
Access Query to import from Sharepoint 0
Setting a default zoom in Infopath 0
Word macro that can call cells out of Excel for a find and replace 0
Cannot Put A Border Around Numbered Text. What To Do? 0
Adding data to MS Access from csv file 0

Top