>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
Try
SELECT zip, COUNT(DISTINC customer) FROM mytable GROUP BY 1
--sb--