Support 805.461.7300
Our Technology. Your Success.
Tech Notes

Add a sequence number to your database

  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.

« Back to Tech Notes

I just wanted to share how FABULOUS [Geoff] is and you should keep him for sure! I have had the best service and training from him in the last few days that it has sold me on keeping AccuZIP @ my new job. I was new to this software and learning in “trial by fire” mode and he got me thru it without any burns! He is amazing and deserves a raise, bonus, employee of year- SOMETHING BIG. I have dealt with the mail industry for about 30 years and never received this level of support and so positive. I am forever grateful and will suggest him and this product if asked. I am being very serious about his knowledge, skill, and interpersonal skill(hard to find these days).
K.P., Colorado Springs, CO