G
Gaz_Poly
Im running a query which selects an accumulating value. This value is
periodically reset for production reasons. Im trying to select the record
which holds the value before the reset occurs. Ive looked at the HELP system
in Access 2003 to try and see if there is a PreviousRecord command, but to no
avail. FindNext and GoToRecord is available but no good. I cant use MAX.
I dont know anyway of selecting this required field value, so any help would
be very much appreciated
periodically reset for production reasons. Im trying to select the record
which holds the value before the reset occurs. Ive looked at the HELP system
in Access 2003 to try and see if there is a PreviousRecord command, but to no
avail. FindNext and GoToRecord is available but no good. I cant use MAX.
I dont know anyway of selecting this required field value, so any help would
be very much appreciated