From the course: Access 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Group and sort records

Group and sort records

From the course: Access 2019 Essential Training

Start my 1-month free trial

Group and sort records

“

- [Instructor] Understanding the grouping and sorting options available with setting up your reports will allow you to have complete control over the organization of your data. Once again, the layout view is gonna be helpful here, since the report will be populated with live data while you make adjustments, so you can see your changes update in real time. I've created a new query here called check in analysis. It groups all of our room assignment data based off of the room type and name, and the type of bed and day of week that they occurred in. Then we have some summary calculations that'll give us the total number of check-ins for each group as well as the total revenue for each group. I also have a column called sort day which simply gives us a numerical representation of the day of the week. This will allow us to sort our records logically. If we try to sort based off of the day of the week column, then access would do it alphabetically, with Friday first and then Monday, and…

Contents