My Assistant
Site Message
(Message will auto close in 2 seconds)
 need unique zip code for each salesperson from listing of all customers
|
|
 Jul 13 2009, 02:22 PM
Post
#1
|
|
|
New Member Posts: 4  |
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.
|
 |
 
|
 |
Replies
|
Jul 13 2009, 04:29 PM
Post
#2
|
|
|
New Member Posts: 4 |
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. |
|
|
|
Posts in this topic
rth1125 need unique zip code for each salesperson from listing of all customers Jul 13 2009, 02:22 PM
debra_dixon Re: need unique zip code for each salesperson from listing of all customers Jul 13 2009, 02:41 PM boblarson Re: need unique zip code for each salesperson from listing of all customers Jul 13 2009, 03:13 PM rth1125 Re: need unique zip code for each salesperson from listing of all customers Jul 13 2009, 04:29 PM boblarson Re: need unique zip code for each salesperson from listing of all customers Jul 13 2009, 04:35 PM rth1125 Re: need unique zip code for each salesperson from listing of all customers Jul 13 2009, 04:48 PM
rth1125 Re: need unique zip code for each salesperson from listing of all customers Jul 13 2009, 05:21 PM |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 08:31 AM |