displaying subform infor on 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****

Please Help!
 
E

Emily

I am not an expert! But, I thought I would share my thought on how to
approach this.

I would start by creating a query that will pull the summary data that you
want for each employee. Then perhaps you could create a second sub-form on
the main form that is based on that summary query.
 

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
Getting summary totals from a subform and display it in main form? 0
Howadd totals in specificRange from subform and display it in main 0
Problem with form--subform 5
'No Current Record' error from subform on Close 1
subform infor on main form! 1
Use TextBox on the main form to limit SubForm 2
row height in a subform 1

Top