shift schedule

[LtFass]

First I want to thank Ken Snell for all of your help the answers you provided
worked great!
Now for the challange The fire dept works a schedule that goes like this for
each shift X-O-X-O-X-O-O-O-O, where the "X"s represent the on duty time and
"O"s are off duty this repeats its self through out the year. The "on-duty"
time begins at 08:00 and ends at 07:59 the following day. The progression
goes like this A-B-A-C-A-C-B-C-B-A-B where "A" is one shift and "B" is the
next and so on.
Ok now what I want to do (and this may not be the right forum to post in) is
to be able to have a selection box (either list of combo) that when the
appropriate shift is selected I can use a formula/routine based on the above
criteria to select on duty people and for the base for reports ect.. I have
posed this to many of my colleages and have not arrived at a solution. Thanks
in advance for all help. Lt.Fass

 

[[MVP] S.Clark]

The short answer is that you'll need to create the criteria entry form,
create the reports, then tie them together using some(not a little, but not
a lot) VBA code. I would estimate about 40-80 hours to complete this... for
an experienced Access developer.
For the DIY, probably a little longer.

I'll admit that I don't understand the logic involved after the appropriate
shift is selected, so maybe providing some exact steps would help.

Finally, forms and formscoding are two newsgroups that deal with form design
and development.