Too many digits after decimal point!

[euphonium01]

I have a Query that takes the 'Price' field, applies a 'Discount' field, which gives me the 'Discount Price'. All this works fine and I get the correct sum. However, after running the Query, and I click in the 'Discount Price' I see about 7 or 8 places after the decimal point. The 'Discount' calculation I'm using in the Query is: Discount Price: CCur([Price])*(1-[Discount])



Sometimes, I do need to enter up to 4 decimal places in the Discount I apply, ie, 14.3815%. Is there a way I can 'round up' the sum to only 2 digits after the decimal point, even if I enter more than 2 decimal places in the Discount applied? I have set the Query Format properties to Decimal, and 2 Decimal places in the appropriate settings...I have also set the same property settings on the Form that the Query is used for, but, I still get the 7 or 8 digits?

Hope this makes sense? Many thanks in anticipation...euphonium01.

[orange]

round() function

Use google to research your concerns/questions.

Try the link in my signature.

[Perceptus]

Check out a UDF that works similar to the excel function RoundUp. just Round with money can cause you to lose pennies while round up will stop that noncents
https://support.office.com/en-us/art...3-db171d0c42a7

[euphonium01]

Thanks to those who suggested using the Roundup function, worked a treat.