Limit to Fields with data

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

MGFoster

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
 
J

John Spencer (MVP)

Have you tried the following in the query grid?

Field: YourField
Criteria: Is Not Null
 
Top