You might get away with just using a query sort order, but you're using text (likely with no corresponding numerical sort field) and text sometimes sorts different from what you expect. Rather than adding a sort field for each ordered field in a single table, each entity should have its own table. Those tables will likely need a sort field as well. You could try to use autonumber as a sort order, but you'd have to ensure that the values you want to see are entered in exactly the same order as the autonumber field. However, if you should later try to insert a record between two others, that will then fail to sort properly. That's why I'd use a numerical sort field for that purpose, and the sort values would increase by something like 5 (5, 10, 15 etc.) If I need to insert between 5 and 10 later, I have four spots to choose from.
EDIT - you don't see the 1st record you expect. What are the first 5 or 10 records you expect and what are the ones you see?
Mock up and copy/paste in/from Excel and you'll automatically get a table in your post.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Windows 10 
Access 2010 32bit
Reply With Quote
Originally Posted by DBenz
