Summing a caluated control in a report

  • Thread starter Thread starter Gary.
  • Start date Start date
G

Gary.

I have a report with a subreport, on the subreportI have two controls
[TotalReceived}
[UnitPrice]
In the subreport I have added a text box where I created the formula (=
[TotalReceived]*[UnitPrice])
Can I sum the text box?
I guess the question I have is can I create a calculated text box and then
sum that control in the footer of the report?

Thanks

Gary Hull
 
On Tue, 11 May 2010 06:19:41 -0700, "Gary." <[email protected]>
wrote:

Yes you can sum it, but you have to repeat the formula"
=sum([TotalReceived]*[UnitPrice])

-Tom.
Microsoft Access MVP
 
Back
Top