If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total Headache
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. -- Michael Conroy Stamford, CT |
#2
|
|||
|
|||
Total Headache
How about creating a subgroup for each guy, and do your COUNT within the group?
"Michael Conroy" wrote: 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. -- Michael Conroy Stamford, CT |
#3
|
|||
|
|||
Total Headache
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 "Dennis" wrote: How about creating a subgroup for each guy, and do your COUNT within the group? "Michael Conroy" wrote: 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. -- Michael Conroy Stamford, CT |
Thread Tools | |
Display Modes | |
|
|