I have a little problem that I am having trouble figuring out.
In my Access database, I have a table of customers. The fields are as follows:
FirstName | LastName | Address | City | State | Zip | Zip4 | Phone | Product
Now this is what I want to do with this information. I am trying to do specific marketing to customers. The information I want to retrieve is out of all the customers, how many unique zip codes do I have and a count of how many unique customers per each unique zip code.
I know I can do:
SELECT DISTINCT customers.Zip
However, this only returns the unique zip codes, and doesn't give me a count of how many customers I have in each of those zip codes.
I know SQL has a count feature, but how would I go about applying it to something like this?