How to have report generate an overall average?

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

Simple question I think...though being my first project, I'm not sure
what to do.

Based on a query of patient information... I am generating a report
that lists the patient's last name, first name, Date of Birth, and
age. First Name, Last Name, and DOB are all from info in a table, and
the "Age" is a calculated field in the query. I set up the report
choosing all of the above fields from the query. If I select grouping
by name, then I get the ability to choose the summary options in which
I can select sum, avg, min and max, based on the "age" numeric field.
If i ask for avg, then when the report generates, it attempts to give
an avg for EACH patient age entry...and does not give an overall
average of ALL patients' ages. I want the report to present much like
this...

Ames, John 10/02/1946 57
Gorns, Phyllis 04/021/1958 45

(2 records)
Avg Age: 51


At the moment I get:

Ames, John 10/02/1946 57
(1 record)
Avg: 57

Gorns, Phyllis 04/021/1958 45
(1 record)
Avg: 45
 
1. Open the report in design view.

2. From the View menu, choose Report Header/Footer.

3. Place the text boxes for your count and average into this section.

You could use a group footer (assigned from the Sorting and Grouping dialog)
if preferred, but you cannot use the Page Footer.
 
Back
Top