how can i use next record from other last record field in access?

[yanie]

i have 2 field, previous value and next value.
The 1st record from previous value is keyin manually,
while present value are keyin manually everytime.
But the next record for previous value is getting from the last record of
present value. how can i coding it in access?
can any1 help me pls?
thx

 

[Allen Browne]

In general, you should not store the same value in 2 records.
Instead, get Access to look it up when you need it.

For details on how, see:
Subquery basics: Get the value in another record
at:
http://allenbrowne.com/subquery-01.html#AnotherRecord