Count total number of groups in report

  • Thread starter Thread starter Komita
  • Start date Start date
K

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
 
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 said:
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.
Click to expand...


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
 
thank you both that answered. i had done everything except was trying to use
=count in the report footer instead of just =thegroupname

thanks!
 
Back
Top