Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Count total number of groups in report

1,056 views
Skip to first unread message

Gina Whipp

unread,
Mar 4, 2009, 9:57:30 AM3/4/09
to
Komita,

Something like...

SELECT Count([WhateverYouAreGroupingOn]) From YourRecordSource GROUP BY
[WhateverYouAreGroupingOn]

OR

- Create a new text box in either the Group Header or Group Footer.
- Name it GroupCount
- Set the Control Source to =1
- Set the Visible Property to No
- Set the Running Sum property to Over All
- Create a text box in the Report Footer
- Set the Control Source to =[GroupCount]

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Komita" <Kom...@discussions.microsoft.com> wrote in message
news:2D20E926-807B-48A0...@microsoft.com...
> I've had not trouble getting the correct groups showing on my report.
>
> However, at the end of the entire report, I want to put a total number of
> the groups (not records in the groups) that were established in the
> report.
>
> The searches I've found on this direct me to counting records, not groups.
>
> Thanks for any help, Lauri


Marshall Barton

unread,
Mar 4, 2009, 10:06:33 AM3/4/09
to
Komita wrote:

>I've had not trouble getting the correct groups showing on my report.
>
>However, at the end of the entire report, I want to put a total number of
>the groups (not records in the groups) that were established in the report.
>
>The searches I've found on this direct me to counting records, not groups.


Add a text box (named txtGrpCnt) to the group header or
footer section. Set its control source to =1 and RunningSum
property to Over All.

Then the report footer text box can use the expression
=txtGrpCnt

--
Marsh
MVP [MS Access]

Gina Whipp

unread,
Mar 4, 2009, 10:30:05 AM3/4/09
to
Your welcome!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Komita" <Kom...@discussions.microsoft.com> wrote in message

news:7CEA27AD-CF4B-4C08...@microsoft.com...
> thank you both that answered. i had done everything except was trying to
> use
> =count in the report footer instead of just =thegroupname
>
> thanks!

0 new messages