What I need is:

 

GroupHeader1 Year

  GroupHeader2 Month

     Detail Days

  GroupTrailer1:  Message

 

But some Months won't have Days attached to it.

 

2013

  Jan

   1

   15

   25

  Feb

   3

   5

Message

 

2012

  Oct

  Dec

Message

 

If I suppress the GroupTrailer1:Message when Months<>Max(Months) then the Message appears in between the days. In this case, between Feb 3rd and Feb 5th

 

Suppress the Message when Days <>Max(Days) and the Message never appears at all when Days are empty

 

I tried an If Then Else statement but that didn't work either. 

Any suggestions would be appreciated.

 

 

 

 

 

 

 

The record will always have a Year.  The Year table contains the Message, which is a Text Field in that table.

Each Month could have multiple Days or could have no Days attached to it.

 

If the record contains Days, then the report must show the Year, the Month, each Day, then the Message.

If the record has no Days, then the report should show the Year, each Month, then the Message.

 

I hope this makes more sense.......