Re: Splitting a record in two

From: Alan Nicoll (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 14:56:24 -0700

If I follow you, I could then select records for my report
depending on which field was non-zero, and in those shifts
where there was both OT and straight time, the record
would show up twice in the report. Or at any rate, that's
how I think I need to do it.

Thanks for the help. I'm a rank beginner at this and
knowing about IIF will help a lot.

Alan
>-----Original Message-----
>You could have two fields in your "Pay" table one for
regular hrs and one
>for OT. A query could be set to calculate ttl hrs. and an
IIF statement in
>the source fields for the regular and OT fields:
>Regular Hours Field IIF (sum(MyTable.Time) > 40, 40,
sum(MyTable.Time))
>OT Hours Field IIF (sum(myTable.Time) > 40, sum
(myTable.Time) -
>40 )
>HTH
>"Alan Nicoll" <anonymous@discussions.microsoft.com> wrote
in message
>news:614d01c42e2b$18eb4600$a401280a@phx.gbl...
>> I am working on a database that includes overtime
>> calculations. Each record represents a shift worked by
an
>> employee. The problem is that when overtime must be
paid,
>> it often must be paid for only part of a shift.
>>
>> For example, if an employee works 35 hours in his first
>> four shifts, and in his fifth shift he works 8 hours,
>> that's a total of 43 hours for the week. For various
>> reasons it is desirable to create a record, i.e., split
>> that fifth shift into two records, one to be paid at
>> straight time and one to be paid at overtime.
>>
>> Can someone tell me how to do this without getting into
>> Visual Basic?
>>
>> Thanks.
>>
>> Alan
>
>
>.
>

Relevant Pages

  • Re: Splitting a record in two
    ... You could have two fields in your "Pay" table one for regular hrs and one ... The problem is that when overtime must be paid, ... > it often must be paid for only part of a shift. ...
    (microsoft.public.access.queries)
  • Re: Overtime question
    ... paid OT, even though there was a paid day off in the middle of the week. ... I wouldn't take a night job that did not pay a shift ... premium as it speaks volumes about the employer. ...
    (alt.machines.cnc)
  • Splitting a record in two
    ... I am working on a database that includes overtime ... The problem is that when overtime must be paid, ... it often must be paid for only part of a shift. ... if an employee works 35 hours in his first ...
    (microsoft.public.access.queries)
  • Re: Time functions, how do I work out number of hours
    ... > If the rate is really dependent on what time you *start*, ... >> shift and end of shift then calculate how many hrs I should be paid. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: New Years Eve - Thank You!
    ... > Brimstone wrote: ... >>> You and other posters. ... >>> I was wondering how much you got paid for that shift that ended at ...
    (uk.transport.london)