Count Grouping Levels

[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

 

[Marshall Barton]

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.

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