Conditional background color

[aaslezak]

In a report I want one of the fields to be a certain color based on a condition. How could I set that up in a report because when I go to the properties for that field it only allows me to pick one color.



Al

[June7]

Try Conditional Formatting on the ribbon Format tab.

[aaslezak]

The conditional formatting worked really well but I have to add and subtract a date in an expression and how does it know that I want days here is the expression from today's date to the due date Date()-[Projects]![Due Date]<1. Can you add and subtract dates like that and how does it know that I mean days or months or years?

[JoeM]

You can use the DATEADD and DATEDIFF functions to do math on dates in Access.
See: http://www.techonthenet.com/access/f...te/dateadd.php
and http://www.techonthenet.com/access/f...e/datediff.php

[June7]

Yes, can add/subtract dates like that. The default unit when adding/subtracting dates is days. To specify other units, use DateAdd and DateDiff functions as indicated by JoeM.

[aaslezak]

Thanks that helped a lot

Al