Re: too complex for me!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Tue, 29 Jun 2004 09:32:25 -0500

I think were making this too hard. The numbers are irrelevant, the fields
"overtime, Vacation, Personal and Holiday hours" are just that, the amount
of hours the employee had - most of the time the value is zero but can be
any number from .1 to 1000. I can sum up all hours worked including 'earned'
hours (via ot, vacation, personal or holiday), but do not know how to
separate 'regular' hours from the 'earned' hours. Let's say an employee
worked a 20 hour week (8 hours on Monday, 8 hours on Tuesday and 4 hours on
Wednesday), used 4 vacation hours (on Wednesday), 12 holiday hours (on 8 on
Thursday and 4 on Friday) and 4 personal hours (on Friday). Now, I have no
problem adding up all of the hours to get 40 for that employee, but, what I
want the report to show at the bottom is...

Regular hours 20
Vacation hours 4
Holiday hours 12
Personal hours 4

I don't know if this can be leveraged but, each 'earned' field has a unique
account number (account numbers are: vacation # 3260, holiday #3265 and
personal #3280) whereas the regular hours do not.

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:eYaaVVYXEHA.3668@TK2MSFTNGP09.phx.gbl...
> I don't see any mention of "overtime, Vacation, Personal and Holiday
hours".
> If we don't see it these fields/values and don't see an example of any
field
> values, I don't know how you expect anyone to tell you how to calculate
the
> values.
>
> WAG is "Wild A** Guess". It is a fairly common abbreviate used on the
> internet.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "RandyH" <rhasby@execpc.com> wrote in message
> news:OFmkxjUXEHA.3668@TK2MSFTNGP09.phx.gbl...
> > Ok, unfamiliar with "WAGs", but I get the jist I didn't supply
enough
> > information - sorry, here goes...
> > My report query (Time Sheet 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Combo Box with multiple selection in text boxes
    ... I am sorry requesting you to find my original post, ... I have another table named Overtime where I want to keep the employee ... holidays in a month and different hours in a holiday. ...
    (microsoft.public.access.forms)
  • Re: Combo Box with multiple selection in text boxes
    ... time it happens that one employee works 5 different holidays in a month. ... Holiday table information? ... I have another table named Overtime where I want to keep the employee ... I want to creat a form where I have a combo box selecting ID or ...
    (microsoft.public.access.forms)
  • Re: too complex for me!
    ... know that the Account Number had anything to do with vacation, holiday,...? ... > "overtime, Vacation, Personal and Holiday hours" are just that, the amount ... > of hours the employee had - most of the time the value is zero but can be ...
    (microsoft.public.access.reports)
  • Re: Combo Box with multiple selection in text boxes
    ... Holiday table information? ... I have another table named Overtime where I want to keep the employee ... I want to creat a form where I have a combo box selecting ID or ...
    (microsoft.public.access.forms)
  • Re: Holiday Dates
    ... In the U.S. holiday means specific days of the year like New Year's Day, ... know as Vacation days. ... The vacation table would need to have the date and the employee table's ... That is a calculation and should not be stored. ...
    (microsoft.public.access.tablesdbdesign)