Calculate value from previous

Hi there

Need some help with a problem I've been strugling with for the past month.
I tried to solve this with a querie but got nowhere.
This is the problem:

I have this collums:

• Income | Outcome | Transport | Total Income | Date

• Total Income (N) = Income (N) + Transport (N-1)

Total income equals income from that day + transport from previous day

• Transport (N) = Total Income (N) - Outcome (N)

Transport from previous day equals Total Income minus outcome


How can I calculate the transport from previous day to sum to next day total income?

Can someone help please?

Best regards.

You need to have a field or fields which you can use to determine which is the previous record. You haven't provided that so the following is a guide only

PreviousDayTransport: Dlookup("Transport","myTable","TDate=" & TDate-1)