Displaying single calculated average numbers in a report

  • Thread starter Thread starter Garth
  • Start date Start date
G

Garth

Hello.
I am creating a database to input evaluations for our
training department to be used for data analysis. One of
the reports is designed to give an instructor
their "Average Score" between a date range. The idea
being able to see how an instructor did score-wise during
a certain month.

I have created a query to average the numbers in the
database and it works fine giving me one number for all
the records by placing a Total row and making Average for
the question Fields and a Sum in the Date Field. However,
when I try to place the Criteria of a date range in the
query design (Between [] And []) and remove the "Sum" for
the Date Totals row, I get individual results for the
averages (I taught 5 classes in the date range, I get 5
results) and not a single number for the classes in the
range which is the goal.

Is there a way I can get just a SINGLE average number
based on a Criteria date? I apologize for being long-
winded. Thank you.

-Garth
Chicago, IL
 
Garth,

Just change the total function in your criteria field (date) to Where.

HTH,
Nikos
 
Back
Top