Sum of a Calculated Field

[LearnersPermit]

I have a fleet db that I'm making changes to. We plan to start charging a sliding rate for each type of vehicle (cars, trucks and vans). I have a report that displays the distance travelled x the rate for that type of vehicle. My problems is that I'm unable to provide a sum of the calculated field.

The calculation of the mileage for each vehicle is =Sum([KMs_Travelled])*([rate]).

When I try to sum this calculation I either get the total kms travelled or the last calculation ($22.50).

Supervisor Km's Travelled Rate Total Per Trip
Al 2500 0.55 $1,375
Dan 50 0.45 $ 22.50

Grand Total 2,550 ??????

The line Grand Total is in the report footer. I'm just not sure how to total the Total Per Trip column.

Thank you for any help.

 

[RoyVidar]

I think I would calculate the Total per trip in the query, just do

TotalTrip: [KMs_Travelled]*[rate]

in the query, then you can sum the TotalTrip after you've added it to the report.


Roy-Vidar

 

[LearnersPermit]

Thank you for your help. It works perfectly.