01-12-2009 11:46 AM
I want to make a customer query by postal codes to get all of the prospects in my territory.
the problem is that I have about 680 different postal codes to enter.
Is there any way to eigher import the list from excel, or to modify an existing query in excel.
I was able to open an existing query in excel, do all of the modifications, but then I loose the format and ACT won't open it.
Any help would be appreciated.
01-12-2009 12:41 PM
I have tried something similar in my database.
I created a query "by range" of zip codes.
Table = Contact / Field_Name = Postcode / Operator = Greater than or equal to "starting post code" AND
Table = Contact / Field_Name = Postcode / Operator = Smaller than or equal to "final post code"
How about it ?
It ´s going to work for you ?
01-12-2009 12:55 PM
I wish it was that easy, but here in canada, we use postal codes that are a mix between letters and numbers. Like N2H 1M2 for exemple.
In the list that I have to import it is only the 3 first digits. and like I said, I have 680 of them.
but thanks for the effort.
01-13-2009 07:39 PM