Returns The Previous Record's Value In Another Field In A Query

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Does any anyone have a procedure for a query where a calculated field returns
the previous record's value in another field. For example:

A
F A
Z F
M Z

The primary key is in random order in the query and the letters ar not sorted.

Thanks,

Steve
 
There is no "previous" record in Access. Consider all records as random
ordered unless you have a value to order them by.
 
Back
Top