Initial Sort Order
By Richard Rost 31 days ago
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 will learn a much more efficient and faster method of numbering records using VBA code and a recordset loop.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Initial Sort Order
Get notifications when this page is updated