I have a text box with a control source:
=[CurrentRecord] & ". " & [ClassTitle] & " (Class starts
in " & DateDiff("d",Now(),[ClassDate]) & " days)"
It displays the record number, class title, and the number
of days until the class starts.
As in: 1. Access Training (Class starts in 5 days)
However, I would like to have it say how many days or
months until the class starts. In case the class start
time is months away, so the message wouldn't be hard to
figure out by the end user (like if there was a class that
started in say... 110 days).
As in: 1. Access Training (Class starts in 3 months and 20
days)
Is there a case statement that could accomplish this
task? Any help would be appreciated!
