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

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.

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.