Running total report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a report in Access which has a running total column,
where for example we guarantee a suppler we will purchase 1,000 units of a
product over the course of a year. The purchases are made at a number of
different times of the year. I would like the running total column to show
the remaining amount of the guaranteed purchase left after each purchase.

Your help is greatly appreciated.
 
In a report, text boxes have a Running Sum property.

Open your report in design view.
Add a text box and set its Running Sum to:
Over Group
The report will show the running sum.
 
Thankyou for your response.
The first transaction on the report' running total is fine, but when the
report prints the other transaction lines the running total adds back in the
full amount of the guarantee purchase of supplies not the remaining balance
left after the previous purchase. I my problem lies in the expression I am
using, which is:

=[GovtGuarantee]-[QuantityOrdered]
 
Okay. Presumably GovtGuarantee is the initial value, and QuantityOrdered is
the one that needs to be collected as a running sum.

Add a text box with these properties:
Name txtQuantityOrderedRS
Control Source =[QuantityOrdered]
Running Sum Over Group
Format General Number
Visible No
This hidden text box collects the running sum.

Now add another text box to show the balance remaining:
ControlSource =[GovtGuarantee] - [txtQuantityOrderedRS]
Format General Number

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Rosz said:
Thankyou for your response.
The first transaction on the report' running total is fine, but when the
report prints the other transaction lines the running total adds back in
the
full amount of the guarantee purchase of supplies not the remaining
balance
left after the previous purchase. I my problem lies in the expression I am
using, which is:

=[GovtGuarantee]-[QuantityOrdered]

Allen Browne said:
In a report, text boxes have a Running Sum property.

Open your report in design view.
Add a text box and set its Running Sum to:
Over Group
The report will show the running sum.
Click to expand...
Click to expand...
 
Back
Top