468,241 Members | 1,718 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,241 developers. It's quick & easy.

need help on count over a second group in Access reports

Hi,

I am doing an expense and funding report which contains a list of
consumers by Region and then by SiteID. For example,

Region: NE
Site: NEMV

1. Mary Doe
2. Len Willams
3. Jack Stack
Site NEMV Totals: 3

Site: NELM

1. Shirley Temple
2. Mary Smith

Site NELM Totals: 2

Region NE: 5

Region: CW
Site: CWBK

1. Amy Wang
2. Shelley Smith
3. Jane Doe

Site CWBK: totals 3
Region CW Totals: 3
TOTAL REPORT: 8
I suppose to get the total of consumers by Site then by Region.

Now, i am getting the count of consumers by site correctly because i
have put a textbox =1 in each consumerName header section and have it
sum "over group". But i can't to get the count of consumer by region
correctly. Is there a way to get the Access to calculate totals over a
"second group(by region)" in a report?

Oct 16 '07 #1
2 1786
On Oct 16, 3:14 pm, hanshirle...@gmail.com wrote:
Hi,

I am doing an expense and funding report which contains a list of
consumers by Region and then by SiteID. For example,

Region: NE
Site: NEMV

1. Mary Doe
2. Len Willams
3. Jack Stack
Site NEMV Totals: 3

Site: NELM

1. Shirley Temple
2. Mary Smith

Site NELM Totals: 2

Region NE: 5

Region: CW
Site: CWBK

1. Amy Wang
2. Shelley Smith
3. Jane Doe

Site CWBK: totals 3
Region CW Totals: 3

TOTAL REPORT: 8

I suppose to get the total of consumers by Site then by Region.

Now, i am getting the count of consumers by site correctly because i
have put a textbox =1 in each consumerName header section and have it
sum "over group". But i can't to get the count of consumer by region
correctly. Is there a way to get the Access to calculate totals over a
"second group(by region)" in a report?
Can't you just add "region" to your Sorting and Grouping?

Oct 16 '07 #2
On Oct 16, 5:59 pm, OldPro <rrossk...@sbcglobal.netwrote:
On Oct 16, 3:14 pm, hanshirle...@gmail.com wrote:


Hi,
I am doing an expense and funding report which contains a list of
consumers by Region and then by SiteID. For example,
Region: NE
Site: NEMV
1. Mary Doe
2. Len Willams
3. Jack Stack
Site NEMV Totals: 3
Site: NELM
1. Shirley Temple
2. Mary Smith
Site NELM Totals: 2
Region NE: 5
Region: CW
Site: CWBK
1. Amy Wang
2. Shelley Smith
3. Jane Doe
Site CWBK: totals 3
Region CW Totals: 3
TOTAL REPORT: 8
I suppose to get the total of consumers by Site then by Region.
Now, i am getting the count of consumers by site correctly because i
have put a textbox =1 in each consumerName header section and have it
sum "over group". But i can't to get the count of consumer by region
correctly. Is there a way to get the Access to calculate totals over a
"second group(by region)" in a report?

Can't you just add "region" to your Sorting and Grouping?- Hide quoted text -

- Show quoted text -
thanks.

yes. i did add "region" to the sorting and grouping. But there are
duplicates, for example,

Name ServiceID amount
Amy Wang DMRS 10,000
Amy Wang MEDI 25,000

where Amy Wang only should count once.

so i use a txtMTSiteTotal to keep track of unduplicate count. But the
same does not work on Region groups.
It seems like Access only allow the textbox with controlsource=1 "No",
"Overall", "over group". When i choose "over group"
it worked for the Site total...with add another textbox does not work
for the Region total.

Oct 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Andrej Hristoliubov | last post: by
2 posts views Thread by Greier Matthias | last post: by
4 posts views Thread by Bob | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.