Total of prices

S

stuck! again!

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?
 
B

Baz

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