I have a field called [Lease End Date] and have created a report where I wish to alert staff 90 days prior to this date that their computer will be up for a change over, so as to make all the required preparations to hand that pc back and be issued with another.
In this report, I have created an unbound object called End Date and it's Control Source is =DateAdd(("d"),-90,[Lease End Date]). This has worked perfectly until it somehow started dropping the desired result for the #NAME? result.
I have tried various remedies, like ensuring the [Lease End Date] is correct and referenced to the right query, but nothing works unless I delete and re-enter the complete =DateAdd(("d"),-90,[Lease End Date]) string. Also, this seems to happen on re-opening the database.
Its driving me bonkers...