Control Source Format for rounding

[David]

I have a box that calculates discounts or allows me to enter a manual amount.
The control source for it is :=IIF([Discount]<=0, [ManDisc],
([DisTx]+[DisNTx])). The last 2 fields handle taxable and non-taxable
discounts. The fields (except for manual)are percentages. These work OK,
but I need it to round to only 2 decimal places. Now when it is stored in
the table, it sometimes has 3 decimal places which messes with the grand
total at the end of the day. Any suggestions?
Thanks!

 

[John W. Vinson]

I have a box that calculates discounts or allows me to enter a manual amount.
The control source for it is :=IIF([Discount]<=0, [ManDisc],
([DisTx]+[DisNTx])). The last 2 fields handle taxable and non-taxable
discounts. The fields (except for manual)are percentages. These work OK,
but I need it to round to only 2 decimal places. Now when it is stored in
the table, it sometimes has 3 decimal places which messes with the grand
total at the end of the day. Any suggestions?
Thanks!

Just use the built in Round function:

=IIF([Discount]<=0, [ManDisc],
Round([DisTx]+[DisNTx], 2)).

John W. Vinson [MVP]