Re: too complex for me!

From: RandyH (rhasby_at_execpc.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 14:48:52 -0500

    Ok, unfamiliar with "WAGs", but I get the jist I didn't supply enough
information - sorry, here goes...
My report query (Time *** Report Query) is pulling data from the 'Time',
'Employees' and 'Accounts' tables. The 'Time' table contains the LaborHours
(text data type), LaborDate and EmployeeID fields with a Record Number
(autonumber key) field. The data from the 'Employees' table contains the
employees first and last name, EmployeeID (key), RegularWage and OTWage
fields. The 'Accounts' table has the AccountNumber (key),
AccountDescription, Departments and EmployeeID fields.
The idea, I guess, is to sum up the LaborHours from each account and show
the totals at the bottom of the report.

Does this help?
Randy

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:O$GnbsTXEHA.3284@TK2MSFTNGP12.phx.gbl...
> Do you have table/field structures to share as well as sample data and
> expected results? Or, do you expect us to make WAGs?
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "RandyH" <rhasby@execpc.com> wrote in message
> news:%23fk1UqSXEHA.716@TK2MSFTNGP11.phx.gbl...
> > TIA
> >
> > I have a simple report based on a parameter query. The report shows
> Account
> > Numbers and the number of Labor Hours that employee spent on that task
> > (account). Then I have a formula on the report footer that totals all of
> the
> > Labor Hours =sum([LaborHours]). This is working well. My problem is that
> now
> > overtime, Vacation, Personal and Holiday hours need to be introduced to
> the
> > report. There are unique account numbers for each of the new parameters.
> > Anybody have any thoughts on how to separate regular hours from
overtime,
> > vacation, personal and holiday on the report footer?
> > i.e. The report footer should show the total of each of these account
> hours
> > on a separate line, like this...
> >
> > Vacation Hours 0
> > Personal Days 0
> > Holidays 0
> > Regular Hours 80
> > Overtime Hours 16
> >
> >
> >
> > Randy
> >
> >
>
>