Count of E-Mails

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

hi,

I have a table that has two fields: Name and E-Mail
address. About half of the people do not have an e-mail
address. I want to run a query shows how many people in
my table have an e-mail address and how many do not.
What is the best way to do this?

Thanks,

Chuck
 
Hi,


SELECT COUNT(EMail) As NumberOfUserWithAnEmail,
COUNT(*) - COUNT(EMail) As NumberOfUserWithout
FROM myTable



COUNT( fieldName ) counts the number of records having a not-null value in
the specified field.
COUNT(*) counts the number of records.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top