Sum TextBox in a Report.

[Lenny]

I have an unbound text box "TotalPayments" with the
control source based on 2 bounded fields, "Payment1"
and "Payment2"
I have created a new text box "SumOfPayments", and want
this box to summarize the total of the
field "TotalPayments".
What do I have to write in the control source?

One solution I have is, to create a query and add a new
field "TotalPayments" amd set the text box "SumOfPayments"
to that field.
Is this the only option?


Thanks

Lenny

 

[John Spencer (MVP)]

You can also repeat your calculations in the report for the SumOfPayments and
sum that.

So, if your source for TotalPayments is
= NZ(Payment1) + Nz(Payment2)

your source for SumOfPayments would be

= Sum(NZ(Payment1) + Nz(Payment2))

Or in this specific case, it could be simply

=Sum(Payment1) + Sum(Payment2)

 

[Lenny]

Thanks
Lenny

-----Original Message-----
You can also repeat your calculations in the report for the SumOfPayments and
sum that.

So, if your source for TotalPayments is
= NZ(Payment1) + Nz(Payment2)

your source for SumOfPayments would be

= Sum(NZ(Payment1) + Nz(Payment2))

Or in this specific case, it could be simply

=Sum(Payment1) + Sum(Payment2)

.