ROUNDING A "GRAND TOTAL"

[jschweitzer via AccessMonster.com]

I have a query in which I created the field "Grand Total" as follows:
Grand Total: [Total Parts Molding]+[Total Parts Assembly]
I would now like to round the number that is returned. I have tried to
change the expression but I continue to receive errors.

Thank you, Jan

 

[geebee]

Hi,

If you want to have zero decimal places, Try....
Format([Grand Total],"#,###0")


Hope this helps
geebee