Splitting a record in two

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

Date: Thu, 29 Apr 2004 13:46:50 -0700

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: 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)
  • Re: TRIM problem - OT and not OT
    ... Thanks for the macro pointer, ... with getting acceptable reporting for management on two types of overtime - ... where a single 12-hour shift is covered for the whole week by two nurses or ... to the quality of care for the patients. ...
    (microsoft.public.excel)