G Guest Sep 15, 2004 #1 I'm trying to get access to round down a figure (3545) to the nearest 50 and am having great difficulty can anyone help?
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 Sep 15, 2004 #2 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
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
