Hide a certain group footer

[carmela_wong]

I am trying to output a report in which I show the total number of
people if groupfooter is "STAFF" but not if it is "ATTENDEES". The
report will say:

STAFF:
Staff1.......
Staff2......
Total staff members: 2

ATTENDEES:
Attendee1.....
Attendee2....
Attendee3.....
Attendee4....

How do I hide the groupfooter for ATTENDEES? Please help. Thanks a
lot.

[paii, Ron]

<ca**********@hotmail.comwrote in message
news:b6**********************************@l17g2000 pri.googlegroups.com...

I am trying to output a report in which I show the total number of
people if groupfooter is "STAFF" but not if it is "ATTENDEES". The
report will say:

STAFF:
Staff1.......
Staff2......
Total staff members: 2

ATTENDEES:
Attendee1.....
Attendee2....
Attendee3.....
Attendee4....

How do I hide the groupfooter for ATTENDEES? Please help. Thanks a
lot.

In the onFormat event of the groupfooter section, check the value and set
me.Visible to true of false. The event procedure name is based on the
section number and not the group name. This numbering can change if you add
or remove sections causing you program to fail.

[carmela_wong]

Thanks for replying, Ron. How do I check the value? I cannot seem to
find the property that gives the value of the group footer, say I had
a PersonType field which had either STAFF or ATTENDEE. What would I
check for in the group footer?
Me.PersonType.????

Thanks again.

[paii, Ron]

<ca**********@hotmail.comwrote in message
news:b7**********************************@j1g2000p rb.googlegroups.com...

Thanks for replying, Ron. How do I check the value? I cannot seem to
find the property that gives the value of the group footer, say I had
a PersonType field which had either STAFF or ATTENDEE. What would I
check for in the group footer?
Me.PersonType.????

Thanks again.

Check the value of the control that group is using. then set the group
footer's property based on that value.

if me![PersonType] = "STAFF" then
Me.Section(4).Visible = False ' Hide section if STAFF
else
Me.Section(4).Visible = True ' Show section if Not STAFF
endif

Section(4) is generated by the Expression Builder. The value (4) may be
different for your report and can change if you add or remove sections.