Question about a specific query

H

hrbsh97

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!
 
J

John W. Vinson

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]
 
Top