Скачать или смотреть Microsoft Access Specify a Custom Sort Order for Records in your Database

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:    / @599cd  

MEMBERS ONLY VIDEO:    • Custom Sort Order MEMBERS ONLY EXTENDED CUT  

RESOURCES:

FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free101
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection

Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter:   / learningaccess  

Email Me: [email protected]

https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

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