View Single Post
  #6  
Old August 28th, 2005, 11:42 PM
Steve Jorgensen
external usenet poster
 
Posts: n/a
Default

On 28 Aug 2005 07:02:38 -0700, 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


No - that's not true. The report footer's sum (using a Sum([fieldname]) has
the correct total sum value when examined from within groups. It is not a
partial sum depending on where you are in the report when you read it.