subform information on a main form

G

Guest

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

displaying subform infor on main form 1
'No Current Record' error from subform on Close 1
Use TextBox on the main form to limit SubForm 2
prevent subform data until main form has data 2
Using a subform to show newrecord on the main form 1
Should I be using a query? 5
don't save subform data on form dirty 7
subform infor on main form! 1

Top