Easy Update Question

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I am trying to update a table to increase rates by 2.8%
I have done a simple update query with the formula =([rate]*1.028) which
works fine how ever it is not rounding the new value to $0.00 format even
though the field is set to "Currency"
Can someone please tell me what the correct formula is so it rounds the
value either up or down (accordingly) to 2 decimal places?

Many thanks

Matt
 
Try this ---
New Rate: Round([rate]*1.028,2)

NOTE the rounding below --
Expr1 Expr2
3.855 3.86
6.425 6.42
7.71 7.71
8.995 9 ----- rounding up
3.855 3.86
7.71 7.71
6.425 6.42
1.285 1.28
2.57 2.57
 
I am trying to update a table to increase rates by 2.8%
I have done a simple update query with the formula =([rate]*1.028) which
works fine how ever it is not rounding the new value to $0.00 format even
though the field is set to "Currency"
Can someone please tell me what the correct formula is so it rounds the
value either up or down (accordingly) to 2 decimal places?
Click to expand...

Update to

Round([rate] * 1.028, 2)

John W. Vinson[MVP]
 
Thanks John



John Vinson said:
I am trying to update a table to increase rates by 2.8%
I have done a simple update query with the formula =([rate]*1.028) which
works fine how ever it is not rounding the new value to $0.00 format even
though the field is set to "Currency"
Can someone please tell me what the correct formula is so it rounds the
value either up or down (accordingly) to 2 decimal places?
Click to expand...

Update to

Round([rate] * 1.028, 2)

John W. Vinson[MVP]
Click to expand...
 
Back
Top