Making Totals in Main Form

[YvesX54]

Hello,

This must be simple i guess.
I'm trying to display a total (sum) in my main form from values out of my subtable.

Thus Price = SUM(UnitPrice*Units) of all products entered in the subtable.

How can i do this ?

Kind regards, Yves.

 

[Robert Dunstan]

Hi there,

This is how I coped with the problem which may or may not be of use to you.

I have form with a subform which is used to enter a purchase order and I wanted to create a total value of order field on my main form. In the subform are the details of the goods ordered and for each record here I'm showing the line total, this is a calculated field which is performed in the underlying query called LineValue. In the footer of the subform I created a text box and set the recordsource to =Sum([LineValue]) and its visible property to false. This control I called txtLineValue. Then on my main form I created another text box and set its recordsource to =([frmPurchaseOrderSubform].[Form]![txtLineValue]).

HTH
Rob

 

[YvesX54]

If i'm using a table-layout to show the subreport, i can't make the field 'Total' field which is in the subform visible , any solution??

Thanks for the assistance.
Yves.

 

[YvesX54]

Sorry, i misunderstood you, it's working perfectly !

Thanks,
Yves

 

[Robert Dunstan]

Glad you got it working!

I know in the past I've gone around in circles trying to sort out calculations but like everything else I've got there in the end