Rounding to nearest 10c

[Bob]

In my table I have a field TotalAmount, how do I get this to round to the
nearest 10c .....Thanks Bob








..........Jenny Vance

 

[Jeff Boyce]

Are you trying to modify the stored value (use an update query) or just
change how it appears when displayed in a form or report (use the Format()
function).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob]

I want to change the value of a calculation in a text box on a form which
does go to a report...thanks Bob

 

[ras]

v = int(v*10)/10

 

[JK]

Bob,

=Round(YrAmt,*10,1)/10

For something more sophisticated check your mail

Regards
Jacob

 

[JK]

Ras,

The Int() function concatenates the number thus will produce Round down
($12.19 to $12.10), not Round to nearest ($12.20)

To get the nearest:
v = Round(v*10, 1) / 10

Regards
Jacob

 

[ras]

v=round(v*10,2)/10
will work even better