How to Fix Rounding Errors in Microsoft Access when Calculating Commissions, Sales Tax, etc.

Описание: 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!

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:
   • Rounding Errors in Microsoft Access MEMBER...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

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

LEARN MORE:
Rounding Errors: https://599cd.com/RoundingErrors

RECOMMENDED COURSE:
Access Expert 8: https://599cd.com/ACX8

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.