Footer Average

[Mike]

I would like to average two columns in a footer:

[Number_of_Calls] and [Sales]

=Sum([Number_of_Calls) works in the footer but =ave([sales%]) does not. It
gives me an average of an average... I just need a true average of the data.

I also used the following but they don't work

=Sum([Number_of_Calls])/[Sales]) and...

=([Text23]/Text24])

Text 23 represents =Sum([Number_of-Calls]) and Text 24 represents
=Sum([Sales]). These function are entered in the footer of the report...

Any suggestions?

 

[Jeff Boyce]

Mike

"Do the math" in your footer, rather than trying to use calculated controls.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Mike]

Thank you - Works like a charm

Mike

"Do the math" in your footer, rather than trying to use calculated controls.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I would like to average two columns in a footer:

[Number_of_Calls] and [Sales]

=Sum([Number_of_Calls) works in the footer but =ave([sales%]) does not. It
gives me an average of an average... I just need a true average of the data.

I also used the following but they don't work

=Sum([Number_of_Calls])/[Sales]) and...

=([Text23]/Text24])

Text 23 represents =Sum([Number_of-Calls]) and Text 24 represents
=Sum([Sales]). These function are entered in the footer of the report...

Any suggestions?