sum unbound

[David]

I have an unbound text box with the name BagCount and the controlsource
=DCount("Weight","Bags","Bags.PaxNo=" & [PaxNo])

How do I sum this at the bottom of the report?
It have the control source of the sum box =Sum([BagCount]) but that doesn't
work. It throws up a box when I open the report asking me to define BagCount
as if it doesn't exist

David

 

[Duane Hookom]

I don't like using domain aggregate functions in control sources if they can
be calculated from the report's domain (record source).

You could try duplicating your text box and renaming it "txtBagCountRunSum"
and set its Running Sum to Over All. Then add a text box to the report footer
with a control source of:
=txtBagCountRunSum