Medical Report tracked by calendar

[dkestner]

I am having a problem with the correct way to word this request. So, please be kind.

every 45 days I am supposed to get a report and if I do not get a report I need to contact the reporter and request the report.

I have over a 100 people I need to track.

If a report comes in I need to reset the day for another 45 days.

I would like some notification if a report is not received (or entered into the data base).



Is it possible and what type of language do I need to be using to find a solution.

[June7]

Open a form or report each day that lists the reports that are over due. The how depends on your data structure.

You have a master table that has a unique record for each report (or for each person)? Then you have another table where you create a record to 'log in' report when it is received?

Do a query that pulls the most recent 'log in' date for each report/person. This can be an aggregate (GROUP BY) Totals query or http://allenbrowne.com/subquery-01.html#TopN. Do a calc that determines if that date is over 45 days old.

Join that query to the master table to see who has never submitted a report.