From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

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

Group and sort records

Group and sort records

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Group and sort records

“

[Instructor]- Understanding the grouping and sorting options available when setting up your reports, will allow you to have complete control over the organization of your data. Once again, the layout view is going to be helpful here since the report will be populated with live data, while you make adjustments so you can see your changes updated in real time. I've gone ahead and created a new query called "Check In Analysis". Let's open it up and take a look. It groups all of our room assignment data based off of the room type and name. We can also see the type of bed and the day of the week. Then we have a couple of summary calculations that count up how many check-ins fall into each category, as well as a summary here or a sum total of the total revenue for a particular type of room. Finally, I have a column called "Sort Day" which simply gives us a numerical representation of the day of the week, which will allow us to sort our records logically. If we try to sort our data based off…

Contents