Footer Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Thank you - Works like a charm

Jeff Boyce said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top