Grouping in Reports

[Chineham]

I am trying to run a report that has a list of fund names on it and the detail is broken down to a very low level. However, when reporting this information the management team only wants to it on a high level. So what I want to do is this.

For instance if Sarah, John, Marlene and Richard are all in the same class at school and the report details their individual grades and now I want the report to show the highest grade for the class and not the individual.

How can I go about this? Can I write a query to say that where Sarah, John, Marlene and Richard appear it shoudl be shown as 'class A' and the highest grade was...?

 

[Rich]

Totals query GroupBy Class MaxGrade

 

[Chineham]

Can you explain a bit more or maybe a lot more!

 

[David R]

In your query, click the sigma button on the toolbar (greek character, looks like a sideways M).
Make sure your query ONLY has the [Class] field and the [Grade] field in it. Otherwise your data will become strange.

Keep the [Class] field as "Group By", but change the [Grade] field to "Max". Run your query and see if the results are what you want.

HTH,
David R