D
Delenn
Hi,
I'm using Access 97. I have a database which includes a
Form where users can enter various actions that they need
to do:
Fields:
Owner of Action
Action
Target Completion Date
Revised Completion Date [not compulsory to enter]
Date Completed.
I have made a report which lists all actions that have not
been completed.
What I would now like to do is extend this to show all
overdue actions.
Firstly I need to see if there is a revised completion
date, and if so compare it to the current date, and if
there is not a revised date, then compare the current date
to the Target Completion Date.
If the date is after the current date then nothing
happens, but if the date is before the current date then
the report will highlight it [that's the bit I can do!]
I'd really just like some pointers in where to go here.
I'm ok with using access, but I've never come across doing
things with dates before, or editing reports too much, so
a bit of direction would be really appreciated!
Thanks
I'm using Access 97. I have a database which includes a
Form where users can enter various actions that they need
to do:
Fields:
Owner of Action
Action
Target Completion Date
Revised Completion Date [not compulsory to enter]
Date Completed.
I have made a report which lists all actions that have not
been completed.
What I would now like to do is extend this to show all
overdue actions.
Firstly I need to see if there is a revised completion
date, and if so compare it to the current date, and if
there is not a revised date, then compare the current date
to the Target Completion Date.
If the date is after the current date then nothing
happens, but if the date is before the current date then
the report will highlight it [that's the bit I can do!]
I'd really just like some pointers in where to go here.
I'm ok with using access, but I've never come across doing
things with dates before, or editing reports too much, so
a bit of direction would be really appreciated!
Thanks