scheduling cleaning jobs

[Guest]

I am looking for a way to show what jobs are due for cleanning on a given
day. I have a master list of jobs and what locatin they are done in. It
also lists there frequency - mon, or mon,wed, fri, or any combinatin of any
days. However also have once/month and 2 times a month. I have it showing
the jobs due for example on Tues.(today) not sure how to show what is still
past due and how to handle the 2times a month type jobs????

Also???Is there already a sample database - scheduling jobs needing to be
done, and being completed that I can look off of?????

Thanks,
BArb

 

[JK]

Hi Barb,

I don't know of any scheduling templates but that does not mean that there
are none somewhere.

I presume that using once a month you nominate a day of the month e.g. 1st,
10th,15ths, etc. That being the case, the easiest way to setup twice a month
is to create 2 monthly cleaning "events" for the same client, e.g. one for
the 1st and one for the 15th. There is no reason why the same principle work
for twice or more weekly.

When you are scheduling on a day of the month, whether once or twice, you
probably need to test that dates are not falling on a weekend (or holidays
if you want the program to be more sophisticated) by moving such dates to
their respective following or previous working days.

It is hard to be specific how to display a particular weekday or past due
without knowing the structure of your table(s). If you are talking *any* job
that is done on a weekday (say, Tuesday), use a filter:

Me.Filter="[TheJobWeekDay]=" & TheWeekDayYouWantToSee
Me.FiterOn=True
(This will not show monthly cleaning which can fall on any weekday)

To see past due you will need to have a "NextDate" date/Time filed AND a
"Done" (Yes/No) field which are updates daily. You can create a query and
filter it
[NextDate]<Date() and [Done]=No


Regards/JK





|I am looking for a way to show what jobs are due for cleanning on a given
| day. I have a master list of jobs and what locatin they are done in. It
| also lists there frequency - mon, or mon,wed, fri, or any combinatin of
any
| days. However also have once/month and 2 times a month. I have it
showing
| the jobs due for example on Tues.(today) not sure how to show what is
still
| past due and how to handle the 2times a month type jobs????
|
| Also???Is there already a sample database - scheduling jobs needing to be
| done, and being completed that I can look off of?????
|
| Thanks,
| BArb