I need a database that will show an employees scheduled days (Monday
through
Friday). I would like to be able to just use a checkbox on a form and
check
whether they will work that scheduled day or not for the following week.
It
is so easy to just do a checkbox than having to type in Monday, Tuesday,
Wednesday, etc. There are approximately 70 employees with schedules that
change weekly! Then I can produce a query and re****t that will just give
me
those employees that will work on Monday, a separate re****t for Tuesday,
etc.
I also need a re****t that will give me a week at a glance (on one page),
Monday through Friday and under each day heading, what employees will be
working. I have gotten as far as making the initial table with all usual
employee info. I could even get my checkboxes to print out the queries
and
re****ts I needed for the separate day re****ts by using the "Yes" criteria
in
my query. The problem is in the week re****t. I just couldn't get it to
work, and so I've scrapped the whole checkbox thing and am starting from
scratch. What do you suggest? I'm new to Access, so go easy on the tech
talk.
|
