?
Solved

How to include a total on Access Report

Posted on 2011-02-18
2
Medium Priority
?
333 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 1000 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 1000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

840 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