T
Tammy
I have developed a database in which I am tracking claim data for projects.
The data is modified on a regular basis by analysts located outside of the
office.
The analysts are required to submit reports on the claims they are handling
every 30 days beginning from the date that the record was created. I have a
'modifieddate' field that updates based on the date entered as the create
date for the record, this works, and I can override it if I need to. I need a
30 day, 60 day, 90 day, etc. anniversary set based on this 'modifieddate'
field. This would be the least I'd like to do.
What I would really like to accomplish is a check in system so that the
analyst can be provided with a request to complete the appropriate report and
then they can log when it's done and this would be the start for the 2nd or
60 days report.
Hope someone has a possible solution. I just can't seem to wrap my head
around determining the set up.
Thanks much.
The data is modified on a regular basis by analysts located outside of the
office.
The analysts are required to submit reports on the claims they are handling
every 30 days beginning from the date that the record was created. I have a
'modifieddate' field that updates based on the date entered as the create
date for the record, this works, and I can override it if I need to. I need a
30 day, 60 day, 90 day, etc. anniversary set based on this 'modifieddate'
field. This would be the least I'd like to do.
What I would really like to accomplish is a check in system so that the
analyst can be provided with a request to complete the appropriate report and
then they can log when it's done and this would be the start for the 2nd or
60 days report.
Hope someone has a possible solution. I just can't seem to wrap my head
around determining the set up.
Thanks much.