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

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

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?
 
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?
Click to expand...

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