If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=SUm in subform
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 |
#2
|
|||
|
|||
=SUm in subform
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 "Regan" u24090@uwe wrote in message news:63372f53bafa4@uwe... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form, Subform, Tab key | 2nd_Stage_User | Using Forms | 17 | August 25th, 2006 12:30 AM |
Update combo box in subform (After Update event) | Karl | Using Forms | 10 | April 4th, 2006 07:45 PM |
unlinked subform | Don Barton | Database Design | 5 | May 20th, 2005 12:23 AM |
Subform on Subform problem | JohnB | Using Forms | 4 | April 10th, 2005 12:52 PM |
Need help with cascading combos | Tom | Using Forms | 19 | July 1st, 2004 11:11 PM |