From the course: Microsoft Access: Forms and Reports

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Apply conditional formatting rules

Apply conditional formatting rules

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Apply conditional formatting rules

“

- [Instructor] When skimming a long report, it can be pretty easy to skip right over some very significant information. By utilizing conditional formatting rules within your reports, you can make sure that values that warrant a second look, get noticed. We'll continue building on the Customer Lifetime Sales report from the previous couple of movies. In this report, I'd like to highlight any customer that's only placed a single order with the company. In order to do that, I need to add those values into the underlying query. I'll open up the Customer Lifetime Sales query in Design View. Then we'll come over and add in an additional column to the query's results. We'll do this by going to the Order table and double clicking on CustomerID. Then, in the Totals row, for this new column, I'll change it to Count. When I run the query, we'll see that we have this additional column here at the end called CountOfCustomerID.…

Contents