microsoft access round down function

Mastering Microsoft Access: Round Down Function Explained

By Melissa Smith
AD

Have you ever found yourself rounding off numbers in Microsoft Access only to have the result be slightly off? The issue might lie in how Access handles decimals. In such cases, it's crucial to use the Right function in conjunction with the Round function to get the desired results. This article explores the Microsoft Access Round function and how to make it work to your advantage.

Access stores numbers as decimals, which means it can handle them with a high degree of precision. However, this precision can sometimes lead to unexpected results, especially when dealing with large numbers or numbers with many decimal places. Here's where the Round function steps in.

Understanding the Microsoft Access Round Function

The Round function in Access is used to round a specified number to the nearest integer or to a specified number of digits. The syntax is as follows: Round(number, num_digits), where number is the number to be rounded, and num_digits specifies the level of precision to which the number is to be rounded.

AD
Validation Rules in MS Access: Enhance Data Integrity
Validation Rules in MS Access: Enhance Data Integrity
an image of a computer screen with the names and numbers on it, in microsoft's office window
an image of a computer screen with the names and numbers on it, in microsoft's office window
Handy Cheat Sheets – Microsoft Office | CustomGuide
Handy Cheat Sheets – Microsoft Office | CustomGuide

The Round function is particularly useful when you want to display a figure to a certain degree of accuracy. For example, you might use it to display the price of an item to two decimal places, or to round off the total sales figure to the nearest hundred.

Round Preview: Basic Use

Let's say you have a field named Price in Table1. The Price field represents the price per item, which you want to display rounded off to two decimal places. Here's how you can do it:

the microsoft access key is shown in this screenshote screen shot from windows xp
the microsoft access key is shown in this screenshote screen shot from windows xp
the screenshot shows an image of a webpage with several options to select which item is right for you
the screenshot shows an image of a webpage with several options to select which item is right for you
Microsoft Access tips: Crosstab query tips
Microsoft Access tips: Crosstab query tips

The expression in the label's Control Source property would be: =Round([Table1].[Price], 2). This ensures that the price of each item is rounded off to two decimal places.

Round Preview: Specifying Negative Numbers

What if you want to round off to the nearest whole number, but always round down? You can do this by adding a subtraction operation within the Round function. Here's how:

AD

The expression for rounding off to the nearest whole number and always rounding down is: =Round([Table1].[Price], 0) - Round([Table1].[Price], 0 - Int([Table1].[Price])).

Microsoft Access Programmer - Get a Free Consultation and Quote for Your Database | Just Get Productive
Microsoft Access Programmer - Get a Free Consultation and Quote for Your Database | Just Get Productive
Tutorial - Creating a Contact Management Database (CRM) using Microsoft Access
Tutorial - Creating a Contact Management Database (CRM) using Microsoft Access
Verified: July 2026 ✅
Verified: July 2026 ✅
the microsoft access logo on a red background
the microsoft access logo on a red background
a screenshot of the ms access program
a screenshot of the ms access program
Unleash The Power of Microsoft Access
Unleash The Power of Microsoft Access

The Role of the Right Function in Rounding

Sometimes, you might need to round off numbers to a specific position, rather than a specific number of decimal places. In such cases, the Right function, which extracts characters from a string starting from the right, can be used in conjunction with the Round function.

The syntax for the Right function is as follows: Right(text, num_chars), where text is the string from which the characters are to be extracted, and num_chars is the number of characters to be extracted.

AD

Round & Right: Basic Use

Let's say you have a field named Serial_Number in Table1. You want to display the last three characters of this number, rounded off to the nearest hundred. Here's how you can do it:

How to Use Microsoft Access | TheAppTimes
How to Use Microsoft Access | TheAppTimes

The expression in the label's Control Source property would be: =Round(([Table1].[Serial_Number])/100)*100, followed by a space and the expression: =Right([Table1].[Serial_Number], 3).

Round & Right: Negative Numbers

Just like with the Round function alone, you can add a negation operation to round down to the nearest hundred in the scenario where the last three digits are negative:

AD

The expression for this case would be: =Round(([Table1].[Serial_Number])/100)*100 - Round(([Table1].[Serial_Number])/100)*100 - Int([Table1].[Serial_Number])/100, followed by a space and the expression: =Right([Table1].[Serial_Number], 3).

In mastery of rounding, as in life, practice makes perfect. So, incorporate these methods into your regular Access practice, and you'll soon be rounding numbers with ease.

AD