AccuZIP Inc Postal SoftwareAccuZIP6 Standard EditionAccuZIP6 Business EditionAccuZIP6 Professional EditonMore SolutionsAccuZIP6 Customer TestimonialsContact AccuZIP Inc at 800-233-0555
Technote: W600
Title: Add a Record Number To A Database
Edited: July 1, 2008
  1. From the Edit menu, choose Fields.
  2. Click on the top field name in the list, then, click Insert.
  3. A Newfield will appear. Highlight the Newfield name and type the word: Record.
  4. Make this field a Numeric type field and make the width of it wide enough to accommodate the amount of records in your database. If your database has 5,000 records then your field should be at least 4 characters wide.
  5. Click OK, then click Yes when prompted to make the Structure changes permanent.
  6. From the Edit menu, choose Command.
  7. Click the New button.
  8. In the Save As box, type, "Add a Record Name" and then press Tab.
  9. In the Command Statement Syntax box type the following command:

    Replace all record with recno()

  10. Click Run.