Count Grouping Levels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access XP/Windows XP

Hello,

I have a report that uses grouping levels based on last name. Is there a
function that will tell me how many grouping levels are in the report? I
tried to use the Count function to give me grand totals in the report footer
(which is what I want), however the function told me the total number of
records in the report, not the total number of grouping levels.

Thanks for your help,

Jeff
 
Jeff said:
Access XP/Windows XP

I have a report that uses grouping levels based on last name. Is there a
function that will tell me how many grouping levels are in the report? I
tried to use the Count function to give me grand totals in the report footer
(which is what I want), however the function told me the total number of
records in the report, not the total number of grouping levels.
Click to expand...


Terminology first. A grouping "Level" is an entry in the
Sorting and Grouping window.

To count the number of different names, add a text box
named txtLNameCount to the group's header or footer section.
Set its control source expression to =1 and its RunningSum
property to Over All.

Then, the report footer text box can display the number of
different names by using the expression =txtLNameCount
 
Back
Top