Highilighting Within a Report

[as0423]

I have 3 separate reports in access based on queries that pull out any files that are outstanding for over 30, 60, and 90 days, respectively. Now obviously when I run the outstanding over 30 day report, it includes the files that are outstanding over 60 and 90 days. I'm looking for a way to run one report and use highlighting to differentiate between the files that are outstanding for various amounts of time. For example, if I ran the outstanding over 30 day report, I would like it to differentiate (by highlighting it or making it bold) the files that are outstanding over 60 days, as these are the most urgent.

[rpeare]

Have you looked at conditional formatting?

That's probably the easiest thing to do particularly if you have a field that's already calculating the days overdue.

http://office.microsoft.com/en-us/ac...010208133.aspx

You can likely also do this with VBA code but I would explore conditional formatting first particularly if you have a low number of (3 or less) possible conditions.

[as0423]

That was such a simple solution. Worked perfectly. Thanks so much.