Sum TextBox in a Report.

  • Thread starter Thread starter Lenny
  • Start date Start date
L

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
 
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)
 
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)

.
Click to expand...
 
Back
Top