Running total of transactions where some TAKE AWAY from total

[Eggers]

I have a transactions report, showing all the transactions that have occurred in the last week. My transactions query has an in/out column, for whether money is flowing in or out of the company.

I would like my report to take this into account when calculating the total, so when this is set to out it takes away instead of adding on, but I haven't used Access in a loooong time and I'm struggling. Any help would be really appreciated, thanks

 

[PWise]

iif("in",amount,-amount)

 

[PWise]

sorry should be
iif(inout="in",amount,-amount)

 

[Eggers]

That seems to have worked, thanks a lot