how to total fields within footer

I have a report footer which includes a number of totals fields. Each
of those fields is computed based on various fields in the data set,
using some rather long expressions.
What I need now is to add a new "super total" field that displays the
sum of three of the other total fields. The only way I can reference
the other three fields in the new field's Value property (without
getting a build error) is with an expression like:
=ReportItems("txtTotal1").Value+ReportItems("txtTotal2").Value+ReportItems("txtTotal3").Value
But even then, the new field shows "#Error" anyway. Does anyone know
how to make this work?Try:
=ReportItems!txtTotal1.Value+ReportItems!txtTotal2.Value+ReportItems!txtTotal3.Value
HTH,
Magendo_man
"silverblatt@.att.net" wrote:
> I have a report footer which includes a number of totals fields. Each
> of those fields is computed based on various fields in the data set,
> using some rather long expressions.
> What I need now is to add a new "super total" field that displays the
> sum of three of the other total fields. The only way I can reference
> the other three fields in the new field's Value property (without
> getting a build error) is with an expression like:
> =ReportItems("txtTotal1").Value+ReportItems("txtTotal2").Value+ReportItems("txtTotal3").Value
> But even then, the new field shows "#Error" anyway. Does anyone know
> how to make this work?
>