Solved

How to include a total on Access Report

Posted on 2011-02-18
2
286 Views
Last Modified: 2012-08-14
Hello,

I need to display a calculated value on a report that divides two fiels that are totals.  For example:

Total Age:  4      Total Count:  100
Averge Age:      25

Both the Age and Count are totals and need to divide these. How can I do this on an Access Report?
0
Comment
Question by:gtrapp
2 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 250 total points
ID: 34930097
So, if the ControlSource for TotalAge =Sum([Age])
and the ControlSource for TotalCount = Sum([Count])

you could do this
AverageAge =Sum([Count])/Sum([Age])

OM Gang
0
 
LVL 44

Assisted Solution

by:GRayL
GRayL earned 250 total points
ID: 34930102
If both of those values appear somewhere on your form they are probably  in textboxes  create a third textbox beside those two and in the control source type:

=txtTotCount/txtTotAge

use your actual control names in place of txtTotCount and txtTotAge.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now