By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

needing average..

P: n/a
i have a report with LeaseName and Total with Grand total in the Report
Footer. I need an Average of the Grand Total also. How would I do this? it
would have to be something like Grand total/number of LeaseNames......?
Thanks

--
Message posted via http://www.accessmonster.com

Oct 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
stephendeloach via AccessMonster.com wrote:
i have a report with LeaseName and Total with Grand total in the Report
Footer. I need an Average of the Grand Total also. How would I do this? it
would have to be something like Grand total/number of LeaseNames......?
Thanks
I think this might work. Create a text box in the detail line. Give it
a name One. In the control source, enter =1. Set visible to false.

Create two new text boxes; TotAvg and SumOne.
In Sum1 enter in the control source
=Sum(One)
and set the visible to false.

In TotAvg, in the control source, enter
=[GrandTotal]/[SumOne]
I really don't know what your GrandTotal field name is.

Oct 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.