Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Print Count on CRRT report for crrts with 125 each

The Count on Crrt report will display a list of carrier routes within each ZIP Code, and their counts. If you want to restrict the list of carrier routes on that report to those that have a specific number of records per route, follow the instructions below.

In the example below, this prints a carrier route report for the routes that have at least 125 in each route.

With your database open in AccuZIP6, pull down the Edit menu to Command. Paste this command into the Command Statement Syntax area:

com_Alias=ALIAS()
SELECT LEFT(zip,5)+crrt as zip FROM (ALIAS()) GROUP BY 1 HAVING COUNT(LEFT(zip,5)+crrt)>=125 INTO CURSOR _zips READWRITE
INDEX ON zip TAG zip
SELECT(com_Alias)
REPLACE X WITH "X" FOR SEEK(LEFT(zip,5)+crrt,"_zips")

After running that command, pull down the File menu to Print > Reports.

In the Report Settings window, select the Count on Crrt template from the template pull down menu. Click on the Report Filters button.

In the Search Filter For Report area, type: “X” $ X

Click Save, then print your report. The report will only contain carrier route counts for those that have at least 125 in a route.

« Back to Tech Notes

Your team has been wonderful when my employee passed away 3 years ago. Your staff was kind enough to train me during hard times to continue my mailing business without any interruption.
J.H., Falls Church, VA