How do I round a number in a calculation to two decimal places?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a calculation in a form field: =[Gross] *0.025

I need this to calculate to 2 decimal places and round up or down - ex: .125
would be .13, .124 would be .12.

I am fairly new to Access and am using Access 2002.

Can someone help me, please?

Thank you!
 
Have you tried =Round([Gross] *0.025,2)?
I have a calculation in a form field: =[Gross] *0.025

I need this to calculate to 2 decimal places and round up or down - ex: .125
would be .13, .124 would be .12.

I am fairly new to Access and am using Access 2002.

Can someone help me, please?

Thank you!
Click to expand...
 
This works great ~ I knew it was something simple that I was missing! I had
done the =Round, but didn't enclose the rest as I should have.

Thank you so much!
Jules

ruralguy via AccessMonster.com said:
Have you tried =Round([Gross] *0.025,2)?
I have a calculation in a form field: =[Gross] *0.025

I need this to calculate to 2 decimal places and round up or down - ex: .125
would be .13, .124 would be .12.

I am fairly new to Access and am using Access 2002.

Can someone help me, please?

Thank you!
Click to expand...

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

Message posted via AccessMonster.com
Click to expand...
 
You are welcome. Go into VBA Help with <ALT> F11 and then F1 and key in
Round into the Answer Wizard. There is actually a lot of help there. Also
look in the contents under R in the Functions for additional help.
This works great ~ I knew it was something simple that I was missing! I had
done the =Round, but didn't enclose the rest as I should have.

Thank you so much!
Jules
Have you tried =Round([Gross] *0.025,2)?
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Back
Top