EmployeeID and Work Date

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

Dave Elliott

How can i find the number of employees who are on the same date?
EmployeeID >"2" and Work Date that is the same?

EmployeeID and Work Date are the control sources in my query
 
not sure just what you're after, but you might try a Totals query, grouping
on the date field, and counting the EmployeeID field.

hth
 
Back
Top