Round Down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function in Access that allows Rounding Down? In Excel you can
type in RoudDown to achieve this, but when I tried in Access I received an
error.

Thanks,
 
If you want to round down to the next integer, use the Int() function.

Debug.Print Int(123.8) = 123
 
Hi

You can use
Int([FieldName])

The opposit would be
-Int(-[FieldName])

Hope this helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Trick 1
Rounding up or down in Access 2003 2
Bankers Rounding 1
Possible router problems 9
Access 2007: % fields rounding to nearest integer 3
rounding problem 7
Found a Bug or Error in Access 2002-2003 Round Function 3
How do you round a number DOWN (for age)? 2

Back
Top