Is there a way to total up the values from 'x' amount of rows in a continuous form?

  • Thread starter Thread starter Mojo
  • Start date Start date
M

Mojo

Hi All

I have a calc field in my continuous form and I'd like to total this up as
follows:

<form>

<sub form>
3.50
6.50
7.50
3.50
<sub form>

Total is ????

<form>

Thanks
 
Put a textbox in the subform's Form Footer section. Set its Control Source
to this expression (replace generic expression with the real expression from
the calculated control/field in the subform):

=Sum(EXPRESSION)

The EXPRESSION calculation must involve only fields from the subform's
RecordSource. It cannot use any controls from the subform.
 
Back
Top