Hourly rate changes in payroll system


Hi

Just trying to get ideas as to how to get around the problem of hourly rate changes in a payroll type database. If I place the hourly rate of the employee in the employee table, then it would be easy to get the total amount to pay the person based on the hours worked. But that would mess up my history totals when running a query.

I guess I need to capture the rate being used for the employee for the week worked and store it in a table so that any rate changes in the furure won't affect historical data.

Any ideas or examples of how to get around this?
Thanks
.

Relevant Pages

  • Re: Dlookup (AGAIN!!)
    ... Andi C wrote: ... The employee name is a combo box. ... I am trying to get Dlookup to automatically put in the hourly rate ...
    (microsoft.public.access.forms)
  • Re: Calculating salary
    ... The company pays "straight time" for the first ... last week and the hourly rate of each employee. ... display the employee's gross pay. ...
    (comp.lang.c)
  • Re: Odd doings in California
    ... it would take at least six months to reconfigure ... There's a field for hourly rate for every employee and virtually every ... Change the hourly rate to the minimum wage. ...
    (comp.lang.cobol)
  • Re: Odd doings in California
    ... impossible "because of the age of the state's payroll system which ... There's a field for hourly rate for every employee and virtually every ... Change the hourly rate to the minimum wage. ... correct decision with program logic. ...
    (comp.lang.cobol)
  • Re: Odd doings in California
    ... it would take at least six months to reconfigure ... There's a field for hourly rate for every employee and virtually every ... Change the hourly rate to the minimum wage. ... the pay that they would have received and another for the minimum pay ...
    (comp.lang.cobol)
Loading