Hi. I have a database with customer #'s and zip codes (among other things). How would I do a SQL to give me a report of unique zip codes and unique customer numbers within that zip code.

I can get a listing with unique zips, but it gives me a count of all customers (not ignoring repeat customers).

Thanks, Randy