I posted similar, but maybe made it harder by writing too much. Ill try it this way.
If I have a table and query with 4 fields. ID, Date, Some Name, Amount.
Every record is on the first day of a month and every next record is in the following month. Is there a calculation for the 5th field to return the previous months amount.
Example
Field 1 2 3 4 5
ID12 01apr2016 Any 110
ID13 01May2016 Some 235 110
ID14 01Jun2016 Blabla 385 235
ID15 01Jul2016 More 474 385
In row with ID13 is there an expression or way to return the amount 110 of the previous row, and every record thereafter?