How do I display a footer only when the group has more than 1 record? Thanks
F fredg Sep 7, 2004 #2 How do I display a footer only when the group has more than 1 record? Thanks Click to expand... 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
How do I display a footer only when the group has more than 1 record? Thanks Click to expand... 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
M Marshall Barton Sep 8, 2004 #3 How do I display a footer only when the group has more than 1 record? Click to expand... 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
How do I display a footer only when the group has more than 1 record? Click to expand... 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
G Guest Sep 8, 2004 #4 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 Click to expand...
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 Click to expand...
