Finding records with empty field

gear

Registered User.
Local time
Today, 15:33
Joined
Mar 10, 2007
Messages
112
The last field in my table is 'Comments'. I want to find if any record or records with 'Comments' field empty. I created a query and added all fields from my table. In the criteria section I typed Like "null". But the query is not returning records where 'Comments' field is empty. I have deliberately added (for testing) a few records leaving comments field empty. This can be viewed clearly in Table view. But the query I made is not displaying the records. Please help.
 
Thanks, it works.
 

Users who are viewing this thread

Back
Top Bottom