A query/table shows our monthly financial status. There are expenses and incomes fields. I want to make a new field named:”sumup”. I want this field to be the result of current month incomes minus expenses plus “sumup” from the previous month record.
For example on June we had 3000 income and 2000 expenses. We had 3500 left from May (shown on “sumup” field in May record) . So the “sumup” record for June will be 4500. It look like a bank count turnover report.
In other words, I want to know how can we make a query to use data from previous records on the same table/query.
For example on June we had 3000 income and 2000 expenses. We had 3500 left from May (shown on “sumup” field in May record) . So the “sumup” record for June will be 4500. It look like a bank count turnover report.
In other words, I want to know how can we make a query to use data from previous records on the same table/query.