Forum Discussion
Operation using the previous row data
Hi all, Appologies if this has been answered elsewhere but I can't find a solution that works for me in the other posts... My problem is I need to add data and use result in the next row. ...
- Create a new query that is a copy of your current one.
- Keep only rows that refer to the closing balance.
- In your main table remove all closing balance rows.
- Subtract 1 from the Week no column.
- Merge your closing balance table with your main table using the Week no column.