View Single Post
  #4  
Old August 28th, 2005, 03:02 PM
external usenet poster
 
Posts: n/a
Default

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!