I have 4 groups
and 2 Running Totals

Details = Lt.Hrs

RTHrsByGrp4
SUM of Lt.Hrs for each record on change of Group 4

RTHrsByGrp4COUNT
COUNT of Lt.Hrs for each record on change of Group 4


How can I conditionally suppress all details except the Maximum RTHrsByGrp4COUNT

NOT Maximum ({#RTHrsByGrp4COUNT}) returns an error "this field cannot be summarized"


sample Data:
......Lt.Hrs..RTSum....RTCount
Grp4  1.2.......1.2.......1.....suppress
.........0.5.......1.7.......2.....suppress
.........2.1.......3.8.......3.....visible
Grp4  2.9.......2.9.......1.....suppress
.........1.0.......3.9.......2.....visible

The problem with Next is that if the data in Group4 of the next Group 1's Group 4, is the same as the current Group 4 it suppress the entire group.

example:

Group1 = A
  Group2 = 10
    Group3 = round
      Group4 = red..........this line gets suppress - Don't want that!
Group1 = B
  Group2 = 20
    Group3 = square
      Group4 = red..........this line is visible


edti:
FOUND A SOLUTION

Next(groupedonfieldfield)=groupedonfield               (group4)
AND Next(groupedonfieldfield)=groupedonfield        (group3)


THANKS A MILLION DBlank!


Edited by carstowal - 24 Aug 2009 at 7:54am