Counting Group Header

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

Guest

I have a report that users select criteria for from a menu. Because they
need to select from certain fields, the query is built so that records from
the main table appear numerous times (the fields needed are in the sub table).

I need a count of a control that's in a group header. Of course it can't
simply be counted because it's in the query numerous times (because of the
values in the sub table) so the count is incorrect. I've done a running sum
in the group header but I need the total to show in the report header.

Anyone have any ideas? Hope this makes sense.
 
If you have a running sum in the group header, just reference the control
name in the report footer:
=txtRunningSumTextBoxName
 
If you only want to count the number of group headers, then this solution
assumes the txtRunningSumTextBoxName has a control source of =1.
 
Back
Top