Re: Actual vs Scheduled report
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Thu, 14 Feb 2008 17:21:17 -0600
What data do you have, and how is it laid out in Tables, and exactly what is
it that you want to match up? When you talk of "shifts", if you mean "a
person working a shift," it would be useful information for someone trying
to assist. Please clarify and perhaps someone can make useful suggestions.
Larry Linson
Microsoft Office Access MVP
"Shanin" <Shanin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8C5F3C4-636E-4257-A994-609FA5809A71@xxxxxxxxxxxxxxxx
I'm trying to get a report that will match up scheduled shifts to actual
shifts. Basically grouping by department and totaling by day for each day
in
the date range. I created a report with two unbound sub-reports, one
pulling
from the schedule and one pulling from the actual, but due to the
difference
in shifts, the actual may have 8 shifts worked compared to the scheduled
only
having 4, they don't line up for easy comparison. I can page break by
day,
but then that wastes a lot of paper. Is there any good way to do this
that
is easier or more effective? Both tables the queries pull off of would
have
the same dates and departments. I would like them to split the days in
the
same location so you can compare the shifts easily to see what is extra or
less.
Thanks
.
- Follow-Ups:
- Re: Actual vs Scheduled report
- From: Shanin
- Re: Actual vs Scheduled report
- Prev by Date: Re: Extra page in envelopes
- Next by Date: name of all reports
- Previous by thread: Re: Applying different formatting in the text box that has conditional
- Next by thread: Re: Actual vs Scheduled report
- Index(es):
Relevant Pages
|
