Data from previous record

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

Date: Thu, 29 Apr 2004 15:52:46 -0700

I have some data that I need to interpret based on the
value of the same field in the previous record. If I were
working in a Visual Basic array it would be easy enough,
but I don't know how to do this in Access.

That is: I have a shift code in one field that indicates
(among other things) time of day when an employee worked.
The rate the employee earns depends on Day/Evening/Night
rates. Now, sometimes the shift is coded as "Overtime"
and so doesn't indicate the time of day.

When the shift is coded "Overtime" I want to look back at
the previous record and take the time of day from there.
In most cases this will be correct, which will be more
convenient for the user than just plugging in the Day rate
(user checks all this by hand anyway).

Thanks.

Alan

Relevant Pages

  • 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)
  • Re: Data from previous record
    ... Tips for Access users - http://allenbrowne.com/tips.html ... "Alan Nicoll" wrote in message ... sometimes the shift is coded as "Overtime" ...
    (microsoft.public.access.queries)