Limit to Fields with data

  • Thread starter Thread starter Big Tony
  • Start date Start date
B

Big Tony

I want to make a criterion in a query that specifies that
for the field I am searching for, to only include those
results that have something in the field (data has been
entered), and not those results where the field is blank,
how do I do this?
 
Big said:
I want to make a criterion in a query that specifies that
for the field I am searching for, to only include those
results that have something in the field (data has been
entered), and not those results where the field is blank,
how do I do this?
Click to expand...

WHERE column_name IS NOT NULL
 
Have you tried the following in the query grid?

Field: YourField
Criteria: Is Not Null
 
Back
Top