Rounding

[J]

I was wondering what I would need to do in order to get a field in a
table to round down to the closest 1/2 percent. I would like to have
it so that if I have a number like 25.4 that it would go to 25 or if I
had 25.8 that It would round down to 25.5.

 

[John Vinson]

I was wondering what I would need to do in order to get a field in a
table to round down to the closest 1/2 percent. I would like to have
it so that if I have a number like 25.4 that it would go to 25 or if I
had 25.8 that It would round down to 25.5.

To round down, use

CInt(200 * [fieldname]) / 200

and format the result as Percent. I'm assuming that you're actually
storing 0.254 and formatting it as percent...

John W. Vinson[MVP]