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

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

Guest

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
 
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: (e-mail address removed)
 
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: (e-mail address removed)

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...
 
Back
Top