Hi- I am new to the forum and relatively new to Access.
I have taken a few Access courses and am trying to finish up my 1st major Access project. I am stuck on one thing and am hoping for a little bit of guidance.
I saw alot of posts about dates, but none that dealt with what I want to try to do.
I have a date that a survey was completed in my final report. I want to show this date on the report, but if it has been more than 1 year since the date I want the date to be highlighted so our consultants know they need to make a new visit to the customer.
I think I need to use something like:
([DATE]+365>Date(),
But after this, I get stuck at what I need to do next.
I'm hoping someone will be gracious enough to assist me.
Thanks in advance for any advice you have to offer.
I have taken a few Access courses and am trying to finish up my 1st major Access project. I am stuck on one thing and am hoping for a little bit of guidance.
I saw alot of posts about dates, but none that dealt with what I want to try to do.
I have a date that a survey was completed in my final report. I want to show this date on the report, but if it has been more than 1 year since the date I want the date to be highlighted so our consultants know they need to make a new visit to the customer.
I think I need to use something like:
([DATE]+365>Date(),
But after this, I get stuck at what I need to do next.
I'm hoping someone will be gracious enough to assist me.
Thanks in advance for any advice you have to offer.