How to Fix Rounding Errors in Microsoft Access

In this Microsoft Access tutorial, we're going to take a look at a common problem people have when rounding numbers in Access. Whether you're calculating sales commissions, tax, or anything with a fractional value, this tip is for you.

Luis from Austin, Texas (a Platinum Member) asks: I'm trying to calculate sales rep commissions for my store. Each sales rep gets a 15% commission. His manager gets a 7% commission. That leaves the store with 78% of the order total. However, after doing the math, the numbers aren't coming out right. Help!

Members

Members will see how additional rounding problems can occur with double values. We'll learn how to deal with the dreaded .00000001 problem. We'll write a little VBA loop to create and then fix the issue.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Recommended Course

• Access Expert 8: https://599cd.com/ACX8

Links

• Rounding: https://599cd.com/Round
• Order Discount: https://599cd.com/OrderDiscount

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, rounding errors, math errors, errors calculating commission, .000000000000001 problem with doubles, for next step