Show & hide Group footer

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

I have total in my report's group footer. I want to
introduce logic to show the total only when there are
multiple detail records that go into the total.

How would I do this?

Would the group footer appear and disappear dynamically
depending on the row count in the detail section? If so,
could you show me the code?

Is there a simpler way, such as IIF() logic in an event of
the footer?

Thanks,

Razor
 
You can place a control in the group footer
txtGroupCount
=Count(1)
Then in the On Format event
Cancel = Me.txtGroupCount = 1
 
Back
Top