Hi
Firstly definitely out of my depth as only beginning to build databases but getting there slowly.
I am trying to do the following:
I have a form that I enter when safety checks are required for some property i manage, I then have a report that displays a summary of all the property and date of last checks and date next checks are due.
Is it possible to display any due dates on the report in red when they get to 30 days before that date?
Obviously this would highlight when safety checks are approaching.
any help appreciated
Jon
Firstly definitely out of my depth as only beginning to build databases but getting there slowly.
I am trying to do the following:
I have a form that I enter when safety checks are required for some property i manage, I then have a report that displays a summary of all the property and date of last checks and date next checks are due.
Is it possible to display any due dates on the report in red when they get to 30 days before that date?
Obviously this would highlight when safety checks are approaching.
any help appreciated
Jon
