Running Sum in report - calculating off last number

[Steve R. via AccessMonster.com]

I have a report that tracks spending by Vendor - it looks like this:


Vendor: Acme Products
Spending Allowed: $1,000

PO___DATE____ITEM___AMT_______Running Sum

123___5/17___5 WIDGETS_ $25_____ $25

124___6/17___15 WIDGETS_ $75____ $100

125___7/17___10 WIDGETS_ $50____ $150

I want to use that $150 spent in a calculation - the txtSpendAllow ( $1,000
for this record ) minus the txtAmt - I have txtAmt twice in the detail, the
text box to the right has the properties set to Running Sum

Any Help would be greatly appreciated,

 

[Marshall Barton]

I have a report that tracks spending by Vendor - it looks like this:


Vendor: Acme Products
Spending Allowed: $1,000

PO___DATE____ITEM___AMT_______Running Sum

123___5/17___5 WIDGETS_ $25_____ $25

124___6/17___15 WIDGETS_ $75____ $100

125___7/17___10 WIDGETS_ $50____ $150

I want to use that $150 spent in a calculation - the txtSpendAllow ( $1,000
for this record ) minus the txtAmt - I have txtAmt twice in the detail, the
text box to the right has the properties set to Running Sum

You can calculate the total for the vendor in the vendor
group header section just by using the Sum function. E.g. a
remaining allowed text box could use the expression:
=[spending allowed] - Sum(amt)