Using the Sum() with parent/child form

[herbertioz]

I have to fields in my subform:
Quantity, Price and SubTotal

In my SubTotal field i have the code: =[Quantity] * [Price]

My goal is to Sum the SubTotal field for all records in a field in the main form.

How can I do it? I have tried all kind of code with the expression builder.

Please help

 

[Rich]

=Sum ([Quantity] * [Price])

 

[herbertioz]

It doesn't work. Error

 

[JANR]

If you put a textbox in your subforms footer and call it Total, with the controlsource = Sum([Quantity] * [Price])

Then on your mainform put a textbox with its controlsource:

=NameOfSubform.Form!Total

Replace whats marked in red with your subformname.

JR

 

[herbertioz]

Nice Thank you!