Question about a specific query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there a way to design a query so that it will query fields that ONLY have
information in them? .. I am trying to weed out my records of employees who
DO NOT have email addresses? .. I would appreciate the help :) ..

Many thanks!
 
Hello,

Is there a way to design a query so that it will query fields that ONLY have
information in them? .. I am trying to weed out my records of employees who
DO NOT have email addresses? .. I would appreciate the help :) ..

Many thanks!
Click to expand...

Use a criterion of

IS NOT NULL

on the email field to display only those records with data in that field.

John W. Vinson [MVP]
 
Back
Top