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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to find "almost" duplicates 4
Query returns 9 records with criteria that exists in one record 2
Update Query Question 1
Unmatched query question 3
Query Criteria 2
count # of records 6
Query Result Incorrect 2
Unmatched query between three tables 2

Back
Top