Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced Lookup Based On A List of Zip Codes

Bronze Contributor
Posts: 1,394
Country: USA

Advanced Lookup Based On A List of Zip Codes

I'm creating a list of contacts that are in my db and in the MSA of a certain city.

 

The list includes 57 Zip Codes.

 

I would hate to build an adanced lookup and manually enter the 57 zip codes. 

 

Is there a faster way to enther that many options in an advanced lookup? 

 

WHILE I'M AT IT what about a way to make the bollean option become "OR" instead of "AND"?

 

Many thanks for your help and advice.

John Purdy
ACT! Premium 2016 (V. 18)
Dell XPS Ultrabook with 4GB, Win 10 Pro, & Office 365, 32bit
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Advanced Lookup Based On A List of Zip Codes

Click on the AND to change it to OR.

You may not need to add all 57 zipcodes. The first four numbers designates the region, state and city, the fifth number is a substation with in the city.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Advanced Lookup Based On A List of Zip Codes

There is a SnapInTool call Proximity for Act! that will show you all of the contacts within a specified distance from a zip code.  That would probably work for them.


Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!