o**** rows that are the same

[jrthor2]

If I have a database that has zip code values stored like this in a MS Access database:

10100
10100
10100
10101
10101
10101
10101
10102
10103
10103
10104
10108
10108

What would the sql be to get the counts of each zip code that are the same, so it would return this:

Zip Code Count
10100 3
10101 4
10102 1
10103 2
10104 1
10108 2

Thanks!!!

[jrthor2]

Can anyone please help me with this?

Thanks!!

[jrthor2]

I got it working.