Solved: How to create report using average

[EricM]

This is probably a real easy question and I have rtfm but still cannot figure it out.
I have a table with 5 fields (id,testname,folder,alive,dead,average)
I want to create a report that is grouped by folder, sorted by testname and I get the average of the alive.
For example if I have the following rows in my database
ID TestName Folder Alive Dead Average
1 Utica Memory 76% 24% 1402
2 Utica Routing 99% 1% 25
3 Rome Routing 98% 1% 23
4 Utica Routing 96% 4% 28

I want a report that would show

Folder Routing
Utica (Average of Alive)
Rome (Average of Alive)
Folder Memory
Utica (Average of Alive)

[OBP]

Have you tried using a "Group By" query where the "Totals" are shown?
Can you post a zipped copy of the database with the data that you have shown here in the table?