I have a listing of over 35,000 customers in my database. I am trying to get it filtered to where I get a listing of each zip code that each one of my sales people have customers in. The database does have listing of each customer #, sales info, address info, and each individual sales persons distinct #. I am just at a block on this and it should be so easy. How should I write this query, by the way it needs to be a make table query. Thanks in advance for any help that anyone can give me.

have you tried a group by query? grouping by Zip and sales person?

Also, why does it need to be a "Make Table" query? Are you aware that you can use a query in 99.99% of the places you can use a table?

I have not tried the group by, but will that give me limit the output to one unique entry for each zip code that each sales person is in?
It needs to be a make table query because I am importing that table into a mapping program for our contact management. Sorry about not explaining that in the first statement.

So you are importing using the mapping program and not exporting using Access and the mapping program does not allow you to select a query instead of a table?

You are correct on both statements, I didn't get to choose the mapping program so I am using what I have been given. Do you think I can do this with a select distinct statement? I am just really struggling with the logic on this one for some reason.

I finally got it with my SQL statement using the select distinct! Thanks to all who made the comments!