I have a big challenge :
I have a 'Transactions' table that has a date_completed, source_location, destination_location, and the amount_moved.
I have to display three columns on my report;
Location (locations can be the destination or the source)
the amount taken from it (if it was a source)
and the amount added to it (if it was the destination).
The client wants to choose a date range, and the location.
Should I use running totals for this?
I have a 'Transactions' table that has a date_completed, source_location, destination_location, and the amount_moved.
I have to display three columns on my report;
Location (locations can be the destination or the source)
the amount taken from it (if it was a source)
and the amount added to it (if it was the destination).
The client wants to choose a date range, and the location.
Should I use running totals for this?