Round Function

[gcgoode]

If I had my query set up like this

SELECT Avg(Rate.TotalPremium) AS AvgOfTotalPremium
FROM (Policy INNER JOIN Driver ON Policy.RecordID = Driver.PolicyLinkID) INNER JOIN Rate ON Policy.RecordID = Rate.PolicyLinkID
WHERE (((Driver.Age)>40)
);

But I wanted to insert a round function to round the AvgOfTotalPremium to 2 decimal points, how would I do that?



Any help would be appreciated.

[June7]

Switch query to SQL View and type in the Round() function: Round(Avg(Rate.TotalPremium),2)

Or set rounding with property sheet in query design.

Or set rounding in textbox on report.

[gcgoode]

Thanks that worked!