Summarising calculated controls in reports 1

[sencar]

I have a calculated control on a report that averages values from subforms linked to a main form. That works OK but I can't access the control values in a summary calculation in the report footer. What I'd like to do, for example, is count the number of values within given limits (0 - 9, 10 - 19 etc) and print these in the report footer. I know that you can't use names of calculated controls in a footer summary. If I simply copy the average calculation from the group footer to the report footer I can get an overall average - but that's not what I want! How do I access the values in the group calculated controls?

Hope this makes sense....

Thanks

Brian

 

[Aivars]

Hi!

Write codes in ReportFooter_Format procedure!

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
'Codes of calculation
....
....
End Sub

Aivars