Counting Duplicate Records

[Novix]

Newbie to access here. I'm working on a homework assignment and I'm totally stumped on how to work a query. I'm supposed to design a query that counts the number of counties in a state and display that number. The table has a autonumber PK, name of the county, and the state(this is what is duplicated). I've been trying to figure out how to count the number of times the state is repeated but the book for the class is horrible.

 

[ColinEssex]

Can you have a different county but the same state name?

Col

 

[Novix]

Yes, the table looks kind of like this.

Record County State
1 abc Alaska
2 abd Alaska
3 abe Alaska
4 abf Alabama
5 abg Alabama

Except it has every county for every state in the US.

 

[emijohns]

Take a look at the crosstab query and see where that takes you.

 

[pdx_man]

Since this is a homework assignment, I won't just give you the answer, but point you in the direction. Look up Totals query in Access Help. It will do what you are looking for.