AccuZIP6 Technotes

Technote W111

Print Deliverable Address Warnings Report to records that have more than A1 in the Errno_ field

By default, the Deliverable Address Warnings report prints every deliverable address in your database, as every address has at least an A1 code in the Errno_ field (which indicates that AccuZIP6 found the address in the field called Address, as opposed to Address2 (A2) for instance).

This technote will give you the expression that will enable you to modify the report in order to make the report print only records that have more than A1 in the errno_ field. This could save a lot of paper, and reduce the listed records to only those that have warning codes that would indicate the address may have been changed in some way.

  1. With your database open, pull down the File menu to Print > Reports.
  2. In the Report Templates window, click on the Template pull down menu, and select Deliverable Address Warnings.frx.
  3. Click on the Report Filters button beneath the name of the label template. This is the button that has the red triangle with the arrow inside of the triangle. Clicking on this button will display the Report Filters window.
  4. Under Search Filter for Report, copy or type the following expression into the text box:

UPPER(LEFT(azStatus_,1))="V" AND !"A" $ left(azErrno_,1)

  1. Click Save.

When you print the report, the report will exclude records that only contain A1 in the Errno_ field, which will make the report exclude the records that were already standardized prior to validation.

Keywords: report, deliverable, warning code, print, correcting, correction, correct, standardize, fix, update