Total Headache

[Michael Conroy]

I need help counting the detail in a report. In this instance I have one
group representing the regional managers. In the detail section are the area
manager's names and their unique ID number (AMID), which is a string. The
record source has already been filtered down by criteria, let's say Q1 of
2007. What I want is a count of how many records each area manager has based
on the criteria. When I use =Count(AMID), I get the total for the whole
report (26), not just the one guy. When I use = DCount("[AMID]","[qry
Report]","[AMID] ='" & [AMID] &"'") it asks for a parameter on AMID. I
thought I concatenated the string properly. The field AMID is in the [qry
Report]. I am also a bit confused because some people say you should avoid
using domain aggregate functions in reports. Is there another way to have a
report count up the individual detail records? Thanks in advance.

 

[Dennis]

How about creating a subgroup for each guy, and do your COUNT within the group?

 

[Michael Conroy]

Dennis, thanks, that worked. I didn't realize I could have a report with no
detail, which is what I have now, but it makes sense. Each person is a group
and I am simply not displaying the detail of that group, but I am totaling
it. Talk about overthinking a problem.
--
Michael Conroy
Stamford, CT

How about creating a subgroup for each guy, and do your COUNT within the group?

I need help counting the detail in a report. In this instance I have one
group representing the regional managers. In the detail section are the area
manager's names and their unique ID number (AMID), which is a string. The
record source has already been filtered down by criteria, let's say Q1 of
2007. What I want is a count of how many records each area manager has based
on the criteria. When I use =Count(AMID), I get the total for the whole
report (26), not just the one guy. When I use = DCount("[AMID]","[qry
Report]","[AMID] ='" & [AMID] &"'") it asks for a parameter on AMID. I
thought I concatenated the string properly. The field AMID is in the [qry
Report]. I am also a bit confused because some people say you should avoid
using domain aggregate functions in reports. Is there another way to have a
report count up the individual detail records? Thanks in advance.