Calculate distance for all records from any zip

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Dave
Site Admin
Posts: 620
Joined: Wed Sep 20, 2006 3:20 pm

Calculate distance for all records from any zip

Post by Dave » Mon Sep 29, 2008 11:02 am

If you would like AccuZIP6 to fill in a distance field with the miles from any particular zip code for all records, then download and run the following command.

1. Download and extract the command file. Place the extracted txt file in the AccuZIP6 5.0\Commands folder.
2. Open the database you are running the command on.
3. Validate
4. Pull down Edit>Command
5. Select the command
6. Type in the 5 digit zip when asked.
7. This will create a distance field and a distance from the zip you entered.

You can now use the search editor to find the records.

Post Reply