How do I count the number of group breaks?

[SonOfTed]

I have been gradually moving over to Access from Paradox.

However, one of the simplest features in all computerized reporting is the
counting of group breaks in a report. More often than not, (especially for a
report that has group breaks by an Employee ID, State, or other unique field)
a count is needed.

Examples: Total employees, Total States listed, etc.

The count is the number of GROUP breaks (Employees in the example listed
above), not necessarily the number of rows processed.

Paradox has three settings for its "Count" feature (Normal, Unique, &
Cumulative). In this case I am looking for the Access equivalent of
UniqueCount.

If this feature is NOT available currently with Access, it SHOULD be.

Many of us do not like having to mess around with added code if we
absolutely do not have to.

This is definitely a feature I would like to see added to the Access
software, perhaps even with an online upgrade.

 

[John Spencer]

Add a control to your Group section
Name: txtCountGroup
Control source: =1
Running Sum: OverAll

Add a control to your Report footer
Name: txtGetCountGroup
Control Source: = [txtCountGroup]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================