Solved

How to include a total on Access Report

Posted on 2011-02-18
2
276 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

18 Experts available now in Live!

Get 1:1 Help Now