queries Access 97

  • Thread starter Thread starter GRCC
  • Start date Start date
G

GRCC

I created a pretty elaborate query with the help of people on this
newsgroup. In my table (which is very large, club member info), there is a
field named emailaddress. Not all members in the table have email addresses,
some are blank. I need to pull from the table members info, a list of the
ones with email addresses and a list of the ones without email addresses. I
know it is simple, but I do not know the criteria. I imagine it is "if" ,
but if what?
thanks so much
GRCC
 
Try this sort of SQL:

SELECT * FROM tblMembers WHERE tblMembers.emailAddress IS NULL

and

SELECT * FROM tblMembers WHERE tblMembers.emailAddress IS NOT NULL



Robin Proctor
 
I should have been clearer. Is there a way to do this using my original
query and just adding the emailaddress column at the end and using the
"criteria cell" in that column? The other did not work.
Thanks
Frank
 
Back
Top