Aging report rounding days late

[Gina Maylone]

Hello all!

How do I go about rounding a standard number? I've searched the forums and haven't been able to find anything. I have my query which determines the number of days late an account is.

aging: DateDiff("d",[duedate],Date())

which results in (depending on the date it is run) 32, 62, etc. I want to use the field in statements, but want it to say "30", "60", "90".

Thanks in advance!

[John_G]

aging = (aging \ 10 ) * 10

The backslash is the operator for integer division (32 \ 10 = 3 )

This always rounds down, so 39 \ 10 = 3 as well.

[Gina Maylone]

aging = (aging \ 10 ) * 10

the backslash is the operator for integer division (32 \ 10 = 3 )

this always rounds down, so 39 \ 10 = 3 as well.

beautiful! Thank you john g!!!