Do not show blanks in a query

[Murph]

How do I design a query to eliminate records that have a blank field?

ie -
customer number
name
city
phone
email -

if email is blank I would like to omit that record from the query

 

[DRMOB]

In your query on the Criteria Row under Email type in "Not Null"

 

[Murph]

way to friggin simple.. thanks

In your query on the Criteria Row under Email type in "Not Null"