Filtering Zip Codes

[watergeek]

I have a need to filter a (40,000 records)mailing list down to all records that are within a certain distance. The distance of course will change depending upon the mailing. I found a program that will provide a list of all the zip codes within whatever distance I give it. The list can then be exported in a tab delimited list.

How do I make a relationship that will use this list of zip codes to filter out my list. The zip codes may be within a large number of different ranges, so just doing a find that way is too difficult.

[falkaholic]

You'll have the make a database to match the exported distances. Then import into it every time there is a mail out.

Then in that database, make a calculation fields that is something like this:

if ( DistanceField < WantedDistanceFieldGlobal, "Yes", "No")

That will have a field with "yes" in it if its within your range.

Then in your master database, make another calculation fields that is just:

"Yes"

Then make a related between those 2 calc fields and you have the relation you need.

[watergeek]

Thank you for your reply, however, I am not going to have the distances, only the zip codes.

My imported list of zip codes (from the other program) will be in one file, and my mailing list has the zip codes in another file. My need is not to match with distances but with the zip codes themselves.

[falkaholic]

OK OK OK .... backup.

So what inf do you have?

What do you want to get out of that data?