How to Round Down on Access 2007

Rounding down numbers in Access 2007 does not use the Round function.

Microsoft Access 2007 comes with a built-in rounding function: Round(). This can be confusing though, because this function only rounds up. To round numbers down, you actually ignore the Round function altogether. Instead, you use the integer function INT(). This deletes any fractions or decimals, leaving you with the rounded down number.

Instructions

1. Open the document with the number(s) you wish to round down in Microsoft Access 2007.

2. Enter "INT(X)" (no quotes) into the field(s) where you wish to place the rounded numbers. To select multiple fields, hold SHIFT as you click them.

3. Replace "X" with the value you wish to round down. This can be a single number, a selection of numbers or a value from your data set (in brackets). For example, your final product could look like INT(200.248) or INT([PurchasePrice]).

4. Click to the end of the line, after the closing parenthesis. You can use your mouse or the right arrow key.

5. Hit ENTER.

References

• MC Access: Int Function
• Microsoft Access Tips