From the course: Access 2019: Forms and Reports

Unlock the full course today

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

Advanced conditional formatting

Advanced conditional formatting

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Advanced conditional formatting

“

- [Instructor] Conditional formatting expressions can get pretty sophisticated. And can reference data from other places in your data base. Let's take a look at this query that I have over here called Top 100 Customers. I'll double click on it to open it up. This query is almost an exact copy of the customer lifetime sales query that drives the report. The only difference is is that this one is only pulling out 100 people. The lifetime sales value is sorted numerically. And if I scroll here to the very bottom, we'll see the lowest value that appears on this Top 100 Customers query. Right now, it's eight hundred and five dollars. Now this number is going to change as more people spend money with the company. But, for now, anybody that spent more than or equal to eight hundred and five dollars is, by definition, one of our top 100 customers. We can use this fact back in our report in our conditional formatting. Let's go ahead and close the query. And I'll close the print preview view on…

Contents