Sub-Total in Group (footers) - HELP?

[gilinnc]

I hit a brick wall on this banghead...

I have a report that is created wit the following group:
Group (A)
Group (B)

On Report Design is as follows:
1 =>Report Header
2 =>Page Header
"Title Heading"
"Group A Title Heading"
3 =>Group (A) Header
[Group (A) Field], [Address Field]
4 =>Group (B) Header
5 =>Detail
[Date/Time] [iif expression, result either 1 or 0]
6 =>Group (B) Footer
7 =>Group (A) Footer
[Count records], [iff express. to multiply base on # of 1's = result $$]
9 =>PageFooter
[Today's Date] [Total of iif based on 1's]

I am unable to 'sum' up by Group(A) on line 7 based on the iif expression on line 5. There is an expression on line 5 as follows:
=IIf(Month([GroupB])=(IIf(Month(Now())=1,12,Month(Now())-1)),1,0)

The result on line 5 is either 1 or 0 (numeric), but I am not able to sum it up in the line 7 using the 'sum' function such as follows:
=sum(IIf(Month([calltime])=(IIf(Month(Now())=1,12,Month(Now())-1)),1,0))

If I use the Sum above - each lines shows the number 35 and I have no idea where 35 is coming from.

I would be very thankful and greatful for any of your help in this matter. It will put me on the good track for the new year!

Thanks,

Gil

 

[gilinnc]

I got it guys...it appears I have to place the 'sum' field in the line 6 of the report to get the proper totals.

Sorry for asking...just had to play with it...more...