How to sum records in sub form but display in parent form"

J

jmuirman

I want to show the total [Premium] of say 4 records in the subform, but I
want it to display in the parent form. I tried =sum([premium]) in a control
box but it doesn't work.

Thanks for your help.

John
 
A

Allan Murphy

In the footer of your subform use an unbound text box to total Premium and
call it total_premium or some other name.

Now in your parent form insert another unbound text box and set the data
control source to [name of your subform].[form]![total_premium]

Allan Murphy
Email: [email protected]
 
J

jmuirman

Ahhh...beautiful - Thank Allan!

Allan Murphy said:
In the footer of your subform use an unbound text box to total Premium and
call it total_premium or some other name.

Now in your parent form insert another unbound text box and set the data
control source to [name of your subform].[form]![total_premium]

Allan Murphy
Email: [email protected]

jmuirman said:
I want to show the total [Premium] of say 4 records in the subform, but I
want it to display in the parent form. I tried =sum([premium]) in a control
box but it doesn't work.

Thanks for your help.

John
Click to expand...
Click to expand...
 
Top