EmployeeID and Work Date

[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

 

[tina]

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

 

[Guest]

=Dcount([EmployeeID], "MyTableName", [EmployeeId] > '2' And [WorkDate] =
#??/??/????#)