I am fairly new to this, so please excuse me for not having the proper verbage.
I have created a report in Access 97, with the following information:
Date open, Expected Date of Completion, and Date Closed.
I run reports weekly on all open items. What I need to do is to be able to format the font to turn red in the Expected Date of Completion field if today's date is after the Expected Date of Completion.
Or another scenario might be:
If today's date is 90 past the Date Open field, then turn the font in the Expected Date of Completion Red.
Please Help!
Thank you in advance for any suggestions.
Robin
I have created a report in Access 97, with the following information:
Date open, Expected Date of Completion, and Date Closed.
I run reports weekly on all open items. What I need to do is to be able to format the font to turn red in the Expected Date of Completion field if today's date is after the Expected Date of Completion.
Or another scenario might be:
If today's date is 90 past the Date Open field, then turn the font in the Expected Date of Completion Red.
Please Help!
Thank you in advance for any suggestions.
Robin