473,394 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

In a report, how do I get the averages of each group?

Seth Schrock
2,965 Expert 2GB
In my report, I have groups. I would like to get the averages for certain fields for each group. For example, in my report, I have a grouping on the Loan Processor field. I want the average time it takes each processor to complete their loans. I have the number of days each loan took already in a field.

I have an average of all records in the Report Footer using =Avg(Stage1), I just need the average for each Loan Processor. I found some information online that mentioned something about Group footers, but my report doesn't have any footers except for the Page and Report footers and I can't find a place to turn on or off group footers.
Jan 29 '13 #1

✓ answered by Rabbit

Are you using 2007? Right click the report in design view and click on grouping and sorting. All the options are there.

5 1088
Rabbit
12,516 Expert Mod 8TB
Are you using 2007? Right click the report in design view and click on grouping and sorting. All the options are there.
Jan 29 '13 #2
Seth Schrock
2,965 Expert 2GB
Access 2010. I just have to click on More> to get it to expand and show the option to have a group footer. So do I just use the same Avg() function in the group footer?
Jan 29 '13 #3
Rabbit
12,516 Expert Mod 8TB
That should do it.
Jan 29 '13 #4
Seth Schrock
2,965 Expert 2GB
That worked. Thanks Rabbit.
Jan 30 '13 #5
Rabbit
12,516 Expert Mod 8TB
No problem.
Jan 30 '13 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: throat.wobbler.mangrove | last post by:
Hi, I was hoping someone may be able to help me with a tricky T-SQL problem. I need to come up with a SELECT statement that does basically the following: Select RCRD_REFNO, MAX(MODIF_DTTM)...
4
by: Hans | last post by:
Hi, I want to create a report. The query looks like this: SELECT A.Name, Sum(A.Hours) AS FROM A GROUP BY A.Name; Now I want in my report to have a last line with the total hours from all....
0
by: Melissa | last post by:
I have a grouped report with a subreport in the group footer. The report is set to start a new page for each group. All the labels for fields are in the group header and there is a subreport in the...
1
by: Kat | last post by:
This is a new one on me...a user wants to select a report then see a checkbox list of the "groups" to be included in the report. He wants to turn on/off whether or not to insert a page break...
2
by: jon|k | last post by:
hi all-- i need to do a transformation that removes duplicates (among other things). to accomplish that, i'm trying to use for-each-group, but it doesn't work. i need to select for duplicates by...
7
by: KiwiGenie | last post by:
I have a form which lists selected records, there could be anything from 1 record to all records selected. I want to output a report for each record as HTML. I want each file to take its name from a...
5
by: bbembi_de | last post by:
Hello everyone, I have just a little xslt problem: <xsl:for-each-group select="item" group-by="name"> <xsl:if test="contains(name, 'teststring11')"> <xsl:apply-templates...
2
by: gildward | last post by:
I am using MS Access 2003 and trying to format a report so that after each group, a page is inserted that has some detailed information on it, and I want the page to not show the page header and page...
8
by: julietbrown | last post by:
I'm sure I knew how to do this once, but now I can't find the place to set it. A report has a group header for Organisation and then a detail section for each Contact in that organisation. The...
1
by: Michael Franz | last post by:
Hi! I am quite new in access and had not taken a programer course. I just learned access through research, so please do understand me cause I realy need help on this one. Any info is very much...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.