Question with counting in reports

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

Hello,
I am currently having a problem in a report that I created. I have the data
grouped by "Line" and then the resulting data contains "Associate ID" and
"number of hours worked in this area".

The problem is that when I do a running sum over the total to count the
unique values, the report properly counts only the unique values within each
grouping, but then if that employee worked in two different areas, they are
counted a second time. I am not sure if there is a way to solve this
problem, since it makes the report useless. I don't want to have to re-group
, since it makes the report useless.

Is there any other way to do this aside from using a running sum over all?

Thanks in advance.
 
It sounds as if you may need to use a sub-report in the report's footer to get
the desired information.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Thanks again for your help. I am not exactly sure how to do this with a
sub-report. Any further assistance would be greatly appreciated
 
Actually, with a little bit of trial and error I got this working. I really
do appreciate your help. Thanks again. You are the best.
 
Back
Top