RoundUp Currency

[Guest]

I need to RoundUp currency to the nearest dollar. It does this in the table,
but I have a report with Sub Totals and a Grand Total that are still
displaying a decimal. This is even after I changed decimals to 0. I know I
should have to write anything complicated for this.

 

[Guest]

Try writing in the control source of the field
=Round([FieldName])

=Round(Sum([FieldName]))

 

[Guest]

if the round is not working properly, use the format function:

format( sum([filedname]), "0")