rounding nearest 10

Thread starter jgfwd
Start date Apr 18, 2006

J

jgfwd

Apr 18, 2006

#1

I need to round a whold number to the nearest 10 in a query.

J

Jerry Whittle

Apr 18, 2006

#2

CLng([YourNumberField / 10) * 10

J

Jerry Whittle

Apr 18, 2006

#3

Missed a bracket in my last post.

CLng([YourNumberField] / 10) * 10

Share:

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Link

Top