To APB,
I recently created a "tickler" database for our Administrative folks
for reports and tasking.
The table (tblreports and tblTasks) fields include a due date, a completed
date and frequency(weekly, monthly, etc.).
There is an add/edit form for new/existing reports and a switchboard (menu)
with a subform that shows a list of what reports are Overdue, with command
buttons for other duedates such as due this week, due next week, etc.
When the switchboard opens the overdue query runs and list those reports
whose duedate is less than the current date. The other buttons, when
clicked, will run similar queries based on the duedate and the current date.
If you would like to see a screen image and table relationship diagram, send
an email to (e-mail address removed)
Judy
