Re: Splitting a record in two

From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 21:37:01 GMT

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

  • 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: Splitting a record in two
    ... I could then select records for my report ... The problem is that when overtime must be ... >> it often must be paid for only part of a shift. ...
    (microsoft.public.access.queries)
  • Re: Syntax Error
    ... Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele ... different work schedules. ... Overtime Button and a Form to add the overtime hours opens OR a Report ... which shift you are working. ...
    (microsoft.public.access.formscoding)
  • Re: Syntax Error
    ... Jeff Conrad lists a number of good resources for database modelling at ... There are 7 different types of schedules ... Overtime Button and a Form to add the overtime hours opens OR a Report ... Select the Morning shift tab, ...
    (microsoft.public.access.formscoding)
  • Re: Syntax Error
    ... create the query in the QBE it works fine with the WHERE clause hard coded ... There are 7 different types of schedules ... Overtime Button and a Form to add the overtime hours opens OR a Report ... Select the Morning shift tab, ...
    (microsoft.public.access.formscoding)