Totaling datasheet subforms

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

Guest

I'm sure this has been answered somewhere but I can't find it to save my life.

basically, I just tryinh to total a feild [Time] from a datasheet subform on
the main form.

I entered the following as the control source for a text box on the mainform:

=Sum(me.frm_timetrack1.Form!time)
 
Try this
1. Create a field in the subform footer, that sum that field
=Sum([time])

2. Create a field In the mainform, that refer to the sum field in the subform
=[SubFormName].Form.[SumFieldName]
 
Open the subform in design view, using the footer, create a calculated
field called SumTime to total the Time values...
=Sum(Time)
On the main form, create a calculated field to display the subform
value...
(use your own names)
=[Forms]![frmMain]![frmSub].[Form]![SumTime]
Even though Datsheet view doesn't show the footer/SumTime... it's value
is still in there.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Perfect. Thanks.

Ofer said:
Try this
1. Create a field in the subform footer, that sum that field
=Sum([time])

2. Create a field In the mainform, that refer to the sum field in the subform
=[SubFormName].Form.[SumFieldName]
--
I hope that helped
Good luck


Bdavis said:
I'm sure this has been answered somewhere but I can't find it to save my life.

basically, I just tryinh to total a feild [Time] from a datasheet subform on
the main form.

I entered the following as the control source for a text box on the mainform:

=Sum(me.frm_timetrack1.Form!time)
Click to expand...
Click to expand...
 
Back
Top