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.
Thansk for the quick response artemus.
I had thought of that, but would that mean that I have to do it 4 times? I might take another look in the morning after a while away from the screen 🙂