Originally Posted by
nejenkins
The week the unit of time. I do not need the granularity of which day it is.
Each client may have 0-6 jobs scheduled for the week depending on which jobs they are signed up for and the scheduling
There are six categories of work eg house, garden, windows, car.
I want a worker to be able to open the database and run a query (or similar) - the database will ‘known’ what week the current day is in, and give a list of the clients and jobs scheduled for that particular week. I Don’t think I need anything to run when the database is closed. I don’t need the database to ‘push’ notifications of work to the worker
Thanks for interests
So, the source of your information could be a query like this:
Code:
SELECT * FROM tblSchedule WHERE DatePart("WW",schDate)= DatePart("WW",Date());
You can use it as recordsource of a form or report.
Replace the tblSchedule and the schDate with the actual object names of the table of scheduled jobs.
Cheers,
John