Condition Group Footer to be visible based on number of records in detail sectio

I have a report grouped by customer number with account info in the detail
section. I want a subreport in the group footer to be visible if the number
of accounts in the detail section is 1.

Thanks,
ER

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200904/1

Evan_Robitaille via AccessMonster.com wrote:

I have a report grouped by customer number with account info in the detail
section. I want a subreport in the group footer to be visible if the number
of accounts in the detail section is 1.


Add a text box named txtDtlCnt with expression =Count(*)
to the group footer.

Then the footer's Format event can use code like:

Me.subreportcontrol.Visible = (txtDtlCnt 1)

If you want to hide the entire footer section, use the
section's name instead of the subreport control's name.

--
Marsh
MVP [MS Access]