Getting summary totals from a subform and display it in main form?

J

JOM

I have a form that has a subform. The main form contains an employee's ID
and Name. The subform contains the the tasks they did on a day to day basis.
What am trying to do is get "summary Totals" information from the subform
and display it in the main for as follows e.g.
********************************************************
Today This week This month
Total hours 8 40 160
********************************************************

The information that the employee enters in the database is as follows
[TrackDate] 5/26/05
[Task] xyz [totalHours] 2
[Task]abc [totalHours] 3
[Task]efg [totalHours] 3

etc****
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform information on a main form 1
displaying subform infor on main form 1
Howadd totals in specificRange from subform and display it in main 0
'No Current Record' error from subform on Close 1
Display 0 in a textbox that obtains a null value from a subform 6
Use TextBox on the main form to limit SubForm 2
Calculating Sum on Main Frm from 3 Subforms 3
Should I be using a query? 5

Top