COUNT TYPES OF ITEMS IN A FIELD

J

Jim

I have one field defined titled "status". This is a drop-down field
and the options are "Active" or "Inactive".
I need a query which will count the number of "Active" and "Inactive"
in this field. The count function only gives me the total records in
this field. Thanks for your help. I am using Access 2007.
 
J

John Spencer

SELECT Status, Count(Status) as TheCount
FROM [YourTable]
GROUP BY Status

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

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

Top