C
Chatstasy
I have a report that gives me an average of two separate divisions that I am
tracking. The expression is: ="Summary for " & "'Division' = " & " " &
[Division] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail
records") & ")"
Now I need it to give me an average of the total of both divisions. For
example, if both divisions make up a region, I need to get an average for the
region on the field that I call "score"
tracking. The expression is: ="Summary for " & "'Division' = " & " " &
[Division] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail
records") & ")"
Now I need it to give me an average of the total of both divisions. For
example, if both divisions make up a region, I need to get an average for the
region on the field that I call "score"