Setting an Initial Sort Order for Records in a Table

In this Microsoft Access tutorial, I'm going to teach you how to number records sequentially, starting at zero and counting up, so that you can specify an initial sort order which you can then later use to manually reorder your records. We will use an update query and the DCount function.

Members

Members will learn a much more efficient and faster method of numbering records using VBA code and a recordset loop.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Update Queries
• DCount

Links

• Sequential Numbers
• Automatic Record Numbering
• Initial Sort Order
• List Box Move Item

Recommended Courses

• Microsoft Access Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, initial sort order, update query, DCount function, renumber customer ID, Access sort customization, sequential record numbering, Access query design, custom sort field, Access table renumbering