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.

Apply conditional formatting rules

Apply conditional formatting rules

From the course: Access 2019 Essential Training

Start my 1-month free trial

Apply conditional formatting rules

“

- [Instructor] Conditional formatting rules will call attention to specific values that you'd like to highlight in your reports. Let's create a new report to analyze the Landon Hotel's monthly revenue summary. To do that, I wanna make use of this query that we created early in the course called MonthlySummary, but I'd need to make a few changes to it. Let's right click on it, open up in Design View. I'm gonna come up to the Show Table window and open up the RoomRates table. Just gonna double click to add that in, and close this window. Then, I wanna move the assignment ID all the way to the far right. We'll click at the menu top to highlight it, and then click and drag to move it over. Finally, we're gonna add in the column called Rate, double click on that, and come down to the Totals row where it says Group By, and change it to Sum. Now let's take a look at the results here, we can see that we have each month broken out by year, and then we can get a total count of the number of…

Contents