Darin,

I understand about the data for the report being complex, and you
wouldn't need to necessarily follow my suggestion literally by directly
using the query that the report is based on. But I imagine you would be
able to make a query that returns you the number of groups that your
report will contain, and I can't see it is likely that it would be any
slower than the running of the report itself.

--
Steve Schapel, Microsoft Access MVP


wrote:
Thanks for the help guys! When I say "I know how to count the groups",
I meant in the more typical "easy" way of putting a text box in the
group header or footer that is = 1, with a running sum on it, then
setting the format event for the group to something like
"me.groupfooter.visible = me.groupcount 1". Sorry, should have
specified that from the start.

Anyway, Steve J, if I understand your solution correctly, it has the
same problem as the above one... the FIRST group footer gets hidden
even when there are multiple groups, because the subsequent groups
haven't yet been counted. That is my problem, I don't know an EASY way
to get a total group count BEFORE getting to the goup footer for the
first group. That's where Steve S.'s solution comes in, and I may have
to resort to that. It's just that the query that makes up the
recordset for this report is kind of complex, so the part where I would
"insert YourReportQuery" ends up bing a lot more hairy than it would
first appear. I've avoided that, because I thought it might be slow.
But I'll try it to see how it does.

Thanks!