Report Calculation

[SG]

I have 2 unbound controls on my report called 1 called estpricetotal with a
control source of =Sum([Quantity]*[UnitPrice]) and actualpricetotal with a
control source of =Sum([Quantity]*[PricePerUnit])

I want to be able to then calculate a total of the est price total in a
unbound text box in the report footer and a seperate total for the actual
price total in an unbound text box. I have tried an unbound text box with
the control source of =Sum([estpricetotal)] on the report footer but this
only calculates the last entry on the report.

Any help would be much appreciated.

Kind Regards

S

 

[Allen Browne]

You cannot sum a text box.

What happens if you use the same expression in the Control Source of the
text box in the report footer:
=Sum([Quantity]*[UnitPrice])

 

[SG]

Allen,

Thank you that works a treat...

So simple in the end!!

Thank you again

You cannot sum a text box.

What happens if you use the same expression in the Control Source of the
text box in the report footer:
=Sum([Quantity]*[UnitPrice])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have 2 unbound controls on my report called 1 called estpricetotal
with a control source of =Sum([Quantity]*[UnitPrice]) and
actualpricetotal with a control source of =Sum([Quantity]*[PricePerUnit])

I want to be able to then calculate a total of the est price total in a
unbound text box in the report footer and a seperate total for the actual
price total in an unbound text box. I have tried an unbound text box with
the control source of =Sum([estpricetotal)] on the report footer but this
only calculates the last entry on the report.