Hiya,
Fairly new to Access and was wondering what the best way to perform Dcounts on groups in an Access report.
For example, I have 10 employees and the different instances of jobs they can perform are either Clean, Shampoo or Vacuum. I have a query called Details that shows a history of all the jobs they have performed. On my report I want a total for each employee of how many of each job they have performed.
This is what I know of the Dcount function but the result I get (obviously) is the TOTAL number of the jobs at the end of each group.
These are the text boxes I place in the employee footer:
=Dcount("[ServiceID]","Details","[Service ID] = "Clean")
=Dcount("[ServiceID]","Details","[Service ID] = "Shampoo")
=Dcount("[ServiceID]","Details","[Service ID] = "Vacuum")
Can anyone please help me with the syntax to Dcount the values for each individual employee and not the entire total? I know that the reason the total value is being returned is because I am Dcount'ing the entire Details query. How am i able to Dcount each instance of the employee?
Thanks in advance