form/subform totals

[ema]

I need help creating a grand total to appear on a form from the totals in a sub-form. example: I am tracking the number of days absence in the sub-form, there may be more than one total or range of dates. I want to have a grand total of days and have it appear on my main form. This may be an easy one, but if anyone can help it would be appreciated. Thanks...

 

[jboyle]

Give this a try Ema:

=Count(Forms![Absense]![Employees Subform].Form![Days Absent])

Place a test box on your main form and place the above code in the control source.

E-Mail me if this doesn't do the trick for ya...John