Need help with running total of transactions, where some transactions TAKE AWAY

[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

 

[gemma-the-husky]

easy to get it in a report based on the query (because its calculated one time only)

very hard to put this in a query
or to get it on a form based on the query

its hard in forms or queries, because each row of a query/form is really discrete - and you can only get the answer by considering other rows - in a query/form the row order can keep changing, which is why its hard to get a running total!

 

[Eggers]

My reports Record Source is a query, that's all (because I only need data from the previous week)...

I just can't remember how code works and such

 

[namliam]

[incomming] - [outgoing] will calculate per line

Now create a group by query to sum it all up and you get that totaled for the company

Not that hard