Using Sum On form

[Oded Kovach]

Hello there

I have subform that bound to master form

The subform is a continues form that one of the fields is numeric.

I need to summarize it. Therefore i add field on the form footer with the
sum function.

When i run the subform alone the sum function returns summerize of all the
table in the form.

But when i run the master form and i have relationships between the master
form and the subform i would like that the sum function will present me the
summerize only of the data that showed by the relationships and not all the
data

WHere can be the problem?

 

[Allen Browne]

If the number field in the subform is named Amount, set the Control Source
of the text box in its Form Footer section to:
=Sum([Amount])

It will show only the total for records loaded into the subform.