Count based on multiple criteria

[IKinal]

Hi,

I need a count based on two criteria in my table, such as a count of everyone where sex=2 and category=1. Is this possible in an Access query?

Thanks,
I. Kinal

 

[cghoga]

yes.

create a new query
choose your table
select the 3 fields everyone, sex, and category
click the Sigma icon to get the Total row
in the Total row set the everyone field to Count
in the Total row set the Sex and Category fields to Where
enter 2 in the sex criteria and 1 in the category criteria

the SQL looks like this:

SELECT Count(TableName.Everyone) AS CountOfEveryone
FROM TableName
WHERE (((TableName.Sex)=2) AND ((TableName.Category)=1));

hope this helps you.

 

[scriverb]

Try this:

Select Count(*) as CountOfRecords
FROM tblYourTableName as A
WHERE A.Sex = 2 and A.Category = 1;

Just update the red code with your table name, copy and paste into the SQL window of a new query. Let me know if you have any other questions.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[IKinal]

Thank you both for the help - problem solved!

I. Kinal