Does anyone know how to round down in access?

L

Larryos

I'm trying to get access to round down a figure (3545) to the nearest 50 and
am having great difficulty can anyone help?
 
T

Tom Ellison

Dear Larry:

Please try this:

(3545 \ 50) * 50

If you need to handle negative values, test to see if this handles
them as you would need.

Notice the division is with a back-slash which means "integer
division" which drops the fraction.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Top