I have been asked to easily show the difference between a planned and actual date in a report. The request is to have the planned date show up RED and with and "*" by the date. I have created the expression,
Planned IR Date*: IIf(Nz([Planned IR Date])=0,"No Date",[Planned IR Date] & "*")
I have been using conditional format in the report, but cannot this to work yet. By the way, I am a newbie to Access.