Support 805.461.7300
Sales
Our Technology. Your Success.

Create a list of SCF and NDC counts

This command will examine an opened database and will create a new database that lists all of the SCF and NDC facilities for the records in that databse, and the amount of records in each facility.

The database can be opened and exported using any of our available export formats like Excel or CSV, or you can open the database and print the report to PDF or to your printer.

Here is how you will implement the command and reports:

1. Download the facilities.zip and unzip the .frx and .frt into the \AccuZIP6 5.0\Reports\ folder.
2. Unzip the .fxp in the facilities.zip file to the \AccuZIP6 5.0\ folder.
3. Open AccuZIP6 5.0 and any database that contains a field named zip.
4. From the Edit menu, choose Command…
5. Click New to create a command and give the command a name, e.g., SCF and NDC Counts
6. Press TAB and into the Command Statement Syntax box, enter the following command:

=Facilities()

7. Click Run.
8. A Message Box will appear and timeout after 5 seconds when the process has been completed, letting you know where the file has been created.

You can then close the Command window, and open the new Database to print the “Facilities.frx” report.

1. From the File menu choose Open Database
2. Open the *_scf-bmc.dbf created in Step 7 above.
3. From the File menu choose Print > Reports…
a. Note: Instead of Printing the report, you could Export to Excel, CSV or any other supported format.
4. Select the Facilities.frx report and print it.

« Back to Commands

Prior to Accuzip we used SAP Postalsoft. We looked for its replacement and chose Accuzip based on testimonials of how great customer service was and on pricing which was very attractive. Best move we've ever made in software and you folks live up to all the good things I heard. I still get calls every 6 months from FirstLogic ( a distributer of the old Postalsoft and others) to see if I'm still happy with Accuzip. I always say the same thing: Yes, very happy. Thanks for checking in.
B.H., Newtown, PA