Count Grouping Levels in a Report

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
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Grouping Levels 1
Trouble with my sorting and grouping 2
Adjust grouping levels programmatically 2
record count in report 2
Grouping a report 1
increasing the number of grouping levels in MS access Reports 3
Grouping and Sorting a Report On Open Event 3
Coordinating the sort order in a report with the underlying query 2

Top