Form footer using subform data

[Patti]

The parent form only has a combo box that is filled with employee names. The subform has a datasheet view of all the training they've had to date, including the hours. I need to put a text box in the footer of the parent form that will total the hours. Here's what i've tried, but so far no luck.

=Forms![Training Subform]![Training Units] is what I started with. I know this only picks up the value in the first record on the subform, but was trying to build on that

=Me!Sum(Forms![Training Subform]![Training Units]) gives a #Name? error
=Sum(Forms![Training Subform]![Training Units]) gives a #Error? error.

What am I doing wrong?

 

[DEvans]

Hi You might want to try using the domain aggrate function
dsum(field to sum, datatable,criteria) or you could just
use the formula sum(datafield). Try these! use the simple
exampl first, you should need to use the me! etc...

-----Original Message-----
The parent form only has a combo box that is filled with

employee names. The subform has a datasheet view of all
the training they've had to date, including the hours. I
need to put a text box in the footer of the parent form
that will total the hours. Here's what i've tried, but so
far no luck.

=Forms![Training Subform]![Training Units] is what I

started with. I know this only picks up the value in the
first record on the subform, but was trying to build on
that.

=Me!Sum(Forms![Training Subform]![Training Units]) gives a #Name? error.
=Sum(Forms![Training Subform]![Training Units]) gives a #Error? error.

What am I doing wrong?
.

 

[Jennifer H]

You can also add a field in the footer of the subform
that totals the records on the subform. Then reference
that field on the main form.

-----Original Message-----
The parent form only has a combo box that is filled with

employee names. The subform has a datasheet view of all
the training they've had to date, including the hours. I
need to put a text box in the footer of the parent form
that will total the hours. Here's what i've tried, but so
far no luck.

=Forms![Training Subform]![Training Units] is what I

started with. I know this only picks up the value in the
first record on the subform, but was trying to build on
that.

=Me!Sum(Forms![Training Subform]![Training Units]) gives a #Name? error.
=Sum(Forms![Training Subform]![Training Units]) gives a #Error? error.

What am I doing wrong?
.