find a record and move back

[rschultz]

Using Access 97 I need to find any time there is data in the ADJ field, then take that data, move back one record, and place it in the ADJ field in that record. Data will only appear in a table once or twice and always in the record after where it should be. Anyone know an easy way to do that?

 

[rschultz]

hmmmm, doesn't each record have a number? can't I find the record with the data, put that record number into a variable and then go to record number -1 (or something like that) then place the data I found into that record?