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 FOR CHANNEL 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 member here: [ Ссылка ]
MEMBERS ONLY VIDEO: [ Ссылка ]
RESOURCES:
FREE Customer Template Database: [ Ссылка ]
FREE Access Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Your Questions Answered: [ Ссылка ]
Learning Connection 50% OFF: [ Ссылка ]
Richard's Blog: [ Ссылка ]
Access Forum: [ Ссылка ]
Twitter: [ Ссылка ]
Email Me: amicron@gmail.com
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
TOPICS COVERED IN MEMBER VIDEO:
Using DMAX to determine the next SortOrder index
BeforeInsert event instead of Default Value
Multi-user concerns (2 users adding at same time)
Me.Refresh
