Count total number of groups in report

[Komita]

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

 

[Gina Whipp]

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

 

[Marshall Barton]

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

 

[Komita]

thank you both that answered. i had done everything except was trying to use
=count in the report footer instead of just =thegroupname

thanks!

 

[Gina Whipp]

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