Okay, maybe someone can point me in the right direction. I have a database where I am tracking work orders that are either Active or Closed. I have a report which is grouping and sorting by Employee. In the Employee footer I need a control that counts the number of Closed orders only. Count Function doesn't let me give criteria. DCount returns all Closed and I can't make it return those that are equal to the Employee. Any help is appreciated.