Using Sum On form

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

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?
 
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.
 
Back
Top