I am having a problem thinking this one out. I am building an access report that I want to flag dates depending on how the progress is going.
[EstDate] - This is a projected date when work will be done.
[ActualDate] - This is the date when work was completed.
I have a textbox that I want to display on the report depending on condition either "", "In Progress", "Completed, or "Behind Schedule"
I am trying to write a formula in the expression builder of the textbox to do this.
If [EstDate] is null nothing is reported, textbox will be blank.
If [EstDate] is > Date() and [ActualDate] is null then textbox will show "In Progress"
If [EstDate] < [ActualDate] then textbox will show "Behind Schedule".
If [EstDate] > [ActualDate] then textbox will show"Completed"
Am I pushing the limits of the expression builder? I am open to ideas.
Thanks for any assistance,