Count Records or Employees on a Linked Sub-form?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a sub-form which is linked to the main form via master/child links
TimeID
On the sub-form I need to count the number of records and put this in a
textbox so I can use it for my calculation
This sub-form via a combo looks up the appropriate employee via the
EmployeeID number
I need to count the number of employees or records for this sub-form per
single record for the main form
Example: the main form is one record with the sub-form having multiple
records for that main form record
How or what can I do to accomplish this?
Sub-form is named Time and Hours and it is based on the table Hours
The main form is based on the table Time

Thanks,

Dave
 
I have a sub-form which is linked to the main form via master/child links
TimeID
On the sub-form I need to count the number of records and put this in a
textbox so I can use it for my calculation
This sub-form via a combo looks up the appropriate employee via the
EmployeeID number
I need to count the number of employees or records for this sub-form per
single record for the main form
Example: the main form is one record with the sub-form having multiple
records for that main form record
How or what can I do to accomplish this?
Sub-form is named Time and Hours and it is based on the table Hours
The main form is based on the table Time
Click to expand...

Put a textbox in the Subform's Footer; set its Control Source to

=Count(*)

John W. Vinson[MVP]
 
Back
Top