D
Dave Elliott
The below code shows me the number of times A employees is on the same
record
What I really need is to know how many employees worked on the same day and
how many days this occured
this may show up more than once per record on
Example: Forest Gump, Bubba Gump and Leroy Brown all work on Thursday
04/21/05
But on Wednesday 03/16/05 Forest worked by himself
I have a combox box on my form named Employee Time with its control source
set to EmployeeID
it looks up the employee from the employee table
also on the form I have a field named WorkDate with its control source set
to Work Date (Note Spaces)
also a textbox named Text34 which =Format([Work Date],"dddd") 'This shows
the day work was done by week day
Thank You So Much For Trying To Help, This code is for a Very difficult
calculation
=DCount("[EmployeeID]","Employees","[Work Date] = " & Format([Work
Date],"\#mm/dd/yyyy\#"))
record
What I really need is to know how many employees worked on the same day and
how many days this occured
this may show up more than once per record on
Example: Forest Gump, Bubba Gump and Leroy Brown all work on Thursday
04/21/05
But on Wednesday 03/16/05 Forest worked by himself
I have a combox box on my form named Employee Time with its control source
set to EmployeeID
it looks up the employee from the employee table
also on the form I have a field named WorkDate with its control source set
to Work Date (Note Spaces)
also a textbox named Text34 which =Format([Work Date],"dddd") 'This shows
the day work was done by week day
Thank You So Much For Trying To Help, This code is for a Very difficult
calculation
=DCount("[EmployeeID]","Employees","[Work Date] = " & Format([Work
Date],"\#mm/dd/yyyy\#"))