Support 805.461.7300
Sales
Our Technology. Your Success.

Create a new database for every Unique State in the database

This command will identify each unique state in your address list and create one new file for each state represented.
For example, if you have 50 records in Alaska and 100 records in Hawaii, this command will create an Alaska database with your database's 50 Alaska records and a separate Hawaii database with the 100 records from your database that were in the state of Hawaii.

1. Download and extract the unique_st.zip file to the C:\Program Files (x86)\AccuZIP6 5.0 folder.
2. Create a command from the Edit>Command window. Type the following into the Command Statement Syntax area:

 
DO UNIQUE_ST

3. The command will create a directory named “C:\ST files” and populate with separate dbf’s for each state in the database.

« Back to Commands

I Just wanted to let you know we are in the Postal Fort Worth Texas Division and I received a call from someone in their office today wanting to ask me some questions. He asked if I understood about the changes with the move update starting for this month, then he asked me what software we were using. I explained to him that we have been using AccuZIP Software for the last 20 years and I thought you were the #1 in the United States. I told him that you were the only software displayed in the Postal Section of the Smithsonian Institute. He asked me if I had to manually change the updated addresses and I told him no that the Software did it for us and I could print a report showing the old address and the new address. He told me out of 32,000 names that were updated only 3 were wrong and he just wanted to call me to see what Software we were using. Thanks for such good software and support from your company over the past 20 years.
C.K., Wichita Falls, TX