Running Totals

[Trevor Aiston]

I have a form which has a calculated control [Text35] to sum the values of 6
fields on the for
=(Val([Text29])+Val([Text30])+Val([Text31])+Val([Text32])+Val([Text33])+Val([Text34]))

Is there a way to show a running rum of all records on the form?

I've tried puting a calculated control in the footer
=Sum([Text35]).
But returns an error?

TIA
Trevor

 

[Wayne-I-M]

Try

=sum(Val([Text29])+Val([Text30])+Val([Text31])+Val([Text32])+Val([Text33])+Val([Text34]))

Also you may want to add the Nz function if any of your control may be null

=sum(Nz([ControlName],0)+Nz([AnotherControlName],0))

 

[Trevor Aiston]

Thanks for the suggestions

Tried 1st suggestion, still error.

Tried a test of
Sum(NZ([Text29],0)+NZ([Text30],0))

But still error.

ANy other suggestions?

Try

=sum(Val([Text29])+Val([Text30])+Val([Text31])+Val([Text32])+Val([Text33])+Val([Text34]))

Also you may want to add the Nz function if any of your control may be null

=sum(Nz([ControlName],0)+Nz([AnotherControlName],0))


--
Wayne
Manchester, England.

I have a form which has a calculated control [Text35] to sum the values of 6
fields on the form
=(Val([Text29])+Val([Text30])+Val([Text31])+Val([Text32])+Val([Text33])+Val([Text34]))

Is there a way to show a running rum of all records on the form?

I've tried puting a calculated control in the footer
=Sum([Text35]).
But returns an error?

TIA
Trevor