Total of prices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a form and a subform from 2 queries which both work fine. However on
the form or subform i need 2 display a final total of the sale
i already have for each item purchased subtotal:
[products.price]*[sale2.quantity].
It is the sum of these subtotal's i wish 2 no.
No matter what I do, or how I do it I cannot get the total to display.

Could someone please help me?
 
stuck! again! said:
Hi,
I have a form and a subform from 2 queries which both work fine. However on
the form or subform i need 2 display a final total of the sale
i already have for each item purchased subtotal:
[products.price]*[sale2.quantity].
It is the sum of these subtotal's i wish 2 no.
No matter what I do, or how I do it I cannot get the total to display.

Could someone please help me?
Click to expand...

In the subform's footer, create a text box and sret it's control source to:

=Sum([products.price]*[sale2.quantity])
 
Back
Top