Running Total in Report in Reverse

[EvE]

I have written a small Stock system in Access 2000.

I am not so hot on the reporting side of things and wondered if you
could please help. All of my reports run off stored procedures on SQL
Server (2000).

I have a report which (in short) displays in its detail section:

Transaction date, Quantity, Stock Movement Reason, Invoice (if
applicable), Price/Item, Any Notes against the transaction, Location
and Bin Location.

For example:

08/02/2005 3 Stock Used 4.20 LocX Bin N
07/02/2005 10 Stock In 5002 3.75 LocY Bin D
etc

Few things to note:
This specific report is to see transaction history for one stock item
between two dates, sorted by the transaction date DESCENDING.
Secondly, if the record has an invoice attached, the stock is incoming
(positive - or bold black on my report) and if not, it is outgoing
(negative - bold red on my report).

So, question:
How can I have a running total next to my quantity field - which will
show how stock has changed at any given time - ending with (hopefully)
the current stock balance for this item on the first line, so to use
my example:

08/02/2005 3 7 Stock Used 4.20 LocX Bin N
07/02/2005 10 10 Stock In 5002 3.75 LocY Bin D

Any help would be greatly appreciated.
PS: Getting the current stock balance is not my problem, that is
easy, I just want this to display to help the reader understand how
the current stock balance came about.

Thank you in advance,
EvE

 

[JohnFol]

You can set the "Running Sum" property to Yes and since the values are +ve
/ -ve it will increment / decrement depending on the Stock movement.

 

[EvE]

Hello John,
Thank you for your feedback.
No, running sum will not help me. Running sum will work from the top
down of the report, I need the reverse (due to the transaction date
being sorted as DESC). Also, my quantities are not + & -, but red and
black positives - I determine if they represent incoming/outgoing by
having an invoice (or not) attached.

Regards,
EvE