Rounding up a currency field

[Guest]

I'm doing all my working out on a form for summing different class costs to
give a total for the whole semester. The trouble is when I apply a
"([Field]*0.85)" calculation, say, to give a value for 15% discount, on
subtracting that from the original total I get a 3 decimal place value, even
though the currency, 2 dec place setup in the field only displays 2! How do I
round up the real answer to 2 decimal places so that I can then multiply it
to give the correct total for a 12 week semester? By the way, I have the same
problem multiplying by 0.85 just to give a dicounted total! Any help
greatfully received

 

[ruralguy via AccessMonster.com]

Have you looked up the Round() function in VBA help?

I'm doing all my working out on a form for summing different class costs to
give a total for the whole semester. The trouble is when I apply a
"([Field]*0.85)" calculation, say, to give a value for 15% discount, on
subtracting that from the original total I get a 3 decimal place value, even
though the currency, 2 dec place setup in the field only displays 2! How do I
round up the real answer to 2 decimal places so that I can then multiply it
to give the correct total for a 12 week semester? By the way, I have the same
problem multiplying by 0.85 just to give a dicounted total! Any help
greatfully received

 

[Guest]

Hi RG, many, many thanks for answering
The Round() function worked well (I had tried it before but forgot to add
the number of digits required!!!)

--
You''''re never to old to learn......

Have you looked up the Round() function in VBA help?

I'm doing all my working out on a form for summing different class costs to
give a total for the whole semester. The trouble is when I apply a
"([Field]*0.85)" calculation, say, to give a value for 15% discount, on
subtracting that from the original total I get a 3 decimal place value, even
though the currency, 2 dec place setup in the field only displays 2! How do I
round up the real answer to 2 decimal places so that I can then multiply it
to give the correct total for a 12 week semester? By the way, I have the same
problem multiplying by 0.85 just to give a dicounted total! Any help
greatfully received

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

Glad I could help.

Hi RG, many, many thanks for answering
The Round() function worked well (I had tried it before but forgot to add
the number of digits required!!!)

Have you looked up the Round() function in VBA help?

[quoted text clipped - 7 lines]