Using Conditions on reports

[Banelight]

Hi All,

I have reports, that are based around dates. Is it possible to make a report highlight different report outputs according to age?

In other words, if an entry is older than say 15 days, highlight it in blue, if its older than 30 days highlight in orange etc etc

I need to find a way for managers to quickly identify old cases to drill down on.

Thanks in advance

Banelight

 

[pbaldy]

Sure; the simplest method is Conditional Formatting on the ribbon.

 

[Banelight]

hi,

Awesome.....where do you do that?

Sorry I'm still a bit new to access. Im using Access 2013 by the way.

 

[pbaldy]

Like I said, it's on the ribbon. Select a control in design view first.

 

[Banelight]

Ok figured it out thanks...

Now to work out the expressions

 

[pbaldy]

No problem. Post back if you get stuck.