Count Grouping Levels in a Report

  • 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
 
Add a text box to the Last Name header
Name: txtCountLN
Control Source: =1
Running Sum: Over All
Add a text box in the report footer
Control Source: =txtCountLN
 
Back
Top