Simplified report

[Witchcraftz]

Despite Google I can't seem to figure this out.

I have some data in a format similar to:

Name / Style / description / speed / distance
john / driver / careful / 80 / 5500
mary / driver / careful / 70 / 7000
pat / racer / reckless / 100 / 6000
anne / driver / careful / 75 / 1000
peter / racer / reckless / 110 / 6500
don / snail / slow / 60 / 6000


I want my report to total by style, without details and to look like:

driver careful 13500
racer reckless 12500
snail slow 6000

How do you get a report to sum the group items by a specific item and to hide the details of that group summing?

 

[BlueIshDan]

select style, description, sum(distance)
from table_name
group by style, description

 

[Witchcraftz]

So reports are unable to do what I want, I need to define the data recordsource and do my calculations there.