I am a complete novice to Access used an old dos program for years so bare with me. I have converted my old dos files to Access & I can't figure out how to have the records displayed in a "Sorted " fashion. We kept our records using what we call a Shop Order so for example 10-1000 for internal use which would breakdown the 10 being the year 2010 & the 1000 would be the first record for that year and we use the 10 prefix throughout the year only change the last 4 digits each time a new job is entered. What my dilemma is our oldest is lets say 91-1051 to present 10-1071 how can I get them to sort & display each time the Database is opened to be sorted & displayed in progression from 91-????, 92-???? & so on all the way to present 10-????. Any Hints?