Need a count of a Duplicates Query

[AudiA4_20T]

Ok this one shouldn't be hard but I'm having a tough time figuring out the best way to do it.



I have a table with zip codes in it, and each zip might have a letter associated in another column. For example

Column A Column B
20183 P
20183 F
20183 E
20183 P

I want a query that tells me how many P,F, and E's there are for each zip. Is this possible? It's basically a duplicate of a duplicate with a count function.

Thanks in advance you guys are always very helpful

[JoeM]

Create an Aggregate (Totals) Query.

Here's how:
- Create a query and add your "Column A" field, and your "Column B" field TWICE.
- Click on the "Totals" button (looks like a Sigma)
- This will add a Totals row under each field and add the phrase "Group By" under each field
- On the last "Column B" field, change the Totals value of "Group By" to "Count"

This should give you what you want.