Report Footer

[Guest]

How do I display a footer only when the group has more
than 1 record?

Thanks

 

[fredg]

How do I display a footer only when the group has more
than 1 record?

Thanks

I'll assume you mean the Group Footer.

Add an unbound control to the Group Header.
Set it's control Source to
=Count(*)
Set it's RunningTotal to
No.
Name this control
"Counter"

Code the Group Footer Format event:
Cancel = [Counter] = 1

 

[Marshall Barton]

How do I display a footer only when the group has more
than 1 record?

Add a hidden text box named txtCount to the footer and set
its expression to =Count(*)

Then the code in the footer's Format event procedure would
be:

Cancel = Me.txtCount < 2

 

[Guest]

Thank you ...that works superbly!!

-----Original Message-----



Add a hidden text box named txtCount to the footer and set
its expression to =Count(*)

Then the code in the footer's Format event procedure would
be:

Cancel = Me.txtCount < 2