Designing Reports

[jlclark4]

Hey,



I have a database set up and running but I want to make some reports that can replace what people have been doing in excel.

Problem #1: I created a report with names and scores (names can be repeated so when I create the report I want a summary -- average score). Issue is I can not sort the averages in decending order which I need to do. Is there a way I can do that? I know I can set the individual scores that way but that does not help me.

Problem #2: Is it possible to create reports with columns to prevent data from going on two pages. All I am providing is a list of names and averages which could fit onto one page using columns.

Any suggestions are welcome!

Thanks in advance

[pbaldy]

1) Clarify, you want to display the individual records but sort by the average, or just display a single record for each person with their average? The second would be easy, by basing the report on a totals query that averaged the data.

2) In Page Setup you'll see a Columns tab.

[jlclark4]

I found the columns button.

Clarification on question #1.
A. Employee 1
B. Review Score 1
B. Review Score 2
B. Review Score 3
A. Employee 2
B. Review Score 1
B. Review Score 2
B. Review Score 3
A. Employee 3
B. Review Score 1
B. Review Score 2
B. Review Score 3

I want a report to show:

Employee -- Average
Employee -- Average
Employee -- Average

In descending order so those that have 100% are on top. I used the wizard and sorted in descending order but only had the option to do it by score which sorted the "B" components in descending order for each name.

[pbaldy]

You want to base the report on a totals query that only returns the averages.

SELECT Employee, Avg(Score) As AvgScore
FROM TableName
GROUP BY Employee

Changing everything in red to your table and field names of course.