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:35 PM
Post
#2
|
|
|
Utterly Banned Posts: 7,038 |
QUOTE 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?
|
|
|
|
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: 20th May 2013 - 04:27 PM |