How to summarize multiple values

[Matt Leach]

I'm assisting a local bicycle organization with a database that cyclists use to track their total mileage.

Im having some troubles summarizing the mileage.

Everyday, the rider enters information into 2 key fields:

Miles = total number of miles for the day

RideType = type of ride they did (Commute, Trail Riding, Off Road, etc...)

I would like to have the ability to break down the total miles of each ride type.

Currently i have one summary field that gives total miles no matter what type it is but would like a field for:

TotalCommuteMiles

TotalTrailMiles

and so on....

Would i set the field as a calculation and perform an IF statement based on the ride type?

Any assistance would be greatly appreciated. Thanks

[Fitch]

The simplest method only requires one summary field, that's set to the total of Miles. You then create a layout with a sub-summary part on it, that's set to break on RideType. Put the summary field and the RideType field on the sub-summary part. Now sort by RideType. Done.

When you create a new layout, there's a "wizard" that walks you through these steps.

[Matt Leach]

The simplest method only requires one summary field, that's set to the total of Miles. You then create a layout with a sub-summary part on it, that's set to break on RideType. Put the summary field and the RideType field on the sub-summary part. Now sort by RideType. Done.

When you create a new layout, there's a "wizard" that walks you through these steps.

Thanks for the reply, i'll give that a shot.