How do I set up a query returning people WITHOUT e-mail addresses?

[Guest]

I am trying to create a query in Access that will return members from our
database that do NOT have e-mail addresses. Any suggestions as to how to go
about doing this?

 

[Roger Carlson]

Put IS NULL in the criteria for the email field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Worked like a charm. Thanks.

Put IS NULL in the criteria for the email field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John Vinson]

I am trying to create a query in Access that will return members from our
database that do NOT have e-mail addresses. Any suggestions as to how to go
about doing this?

Depends on where the EMail addresses are stored. Roger's answer (a
criterion of IS NULL) is the right way if you have an EMail field in
the Members table; an Unmatched Query Wizard will work if you have a
separate table of email addresses.

John W. Vinson[MVP]