=SUm in subform

[Regan]

Hi, i have a subform(datasheet view) called 'Child4' for a timesheet.
Employees name and a Date is on the form, and the details of what they have
done is entered into the sub form. There is a field called 'Units'. Where
the employee enters how much time they have spent on a particule task. What
i want to do is be able to show Total Units in the 'Timesheet' form so that
each time they enter a new task the total is automatically adjusted so they
can see there total units so far.
Thanks if you can help

 

[Arvin Meyer [MVP]]

Add a footer to the subform and place a textbox called something like
txtTotal in it. For design purposes, you can set both of them to zero inches
in height.

Set the controlsource of the textbox to:

= Sum([Units])

Now, if you've set the height to zero, on the main form, place another
textbox and set it's controlsource to:

Forms!FormName!SubFormControlName.Form!txtTotal
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access