In this Microsoft Access tutorial, I will teach you how to specify a custom sort order that you can use to display records however you like in your tables, queries, forms, and reports.

Joyce asks, "I have a list of companies that I want to put into my reports, but I don’t wanted them listed alphabetically. I need to specify how they’re sorted. How do I do this?"

BONUS CONTENT for YouTube Members

Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show how to have Access automatically determine what the next item in the sort order will be and fill it for you. I'll also address multi-user concerns (what if you both add a new record at the same time).

• Become a YouTube Channel Member here
• Members-only video

Learn More

• Customer Database Template

Resources

• Ask a TechHelp Question
• FREE Access Beginner Level 1
• Access Level 2 for $1.00
• Learning Connection 50% OFF

Questions?

Post your comments or questions below!