Group Footer in a report

[Sue]

I have a database to compile a swimming gala programme.
The gala programme report is grouped by event number so
that the detail shows all the competitors in the event by
their competitor number and then the group footer is the
event number for the final for that particular event with
8 blank lines for people to complete the names on the
night.

If the event has 6 or less competitors I don't want the
group footer for that particular event to be visible or
print when I am creating the programme. How can I change
the visible property for the group footer based on the
number of competitors for an event so that it is visible
only if there are more than 6 competitors for the event?

Please help

Many thanks

Sue

 

[Marshall Barton]

I have a database to compile a swimming gala programme.
The gala programme report is grouped by event number so
that the detail shows all the competitors in the event by
their competitor number and then the group footer is the
event number for the final for that particular event with
8 blank lines for people to complete the names on the
night.

If the event has 6 or less competitors I don't want the
group footer for that particular event to be visible or
print when I am creating the programme. How can I change
the visible property for the group footer based on the
number of competitors for an event so that it is visible
only if there are more than 6 competitors for the event?

Add a (hidden?) text box named txtCountCompetitors to either
the group header footer with the expression =Count(*). This
will tell you how many competitors are in the event.

Now you can a line of code to the group footer section's
Format event to make it invisible when there aren't enough
competitors:

Me.Section(acGroupLevel1Footer).Visible=(txtCountCompetitors>6)