|
||||||
|
Rounding Errors By Richard Rost 2 years ago 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! MembersMembers 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.
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
Links
Keywordsaccess 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
|
||||||||||||||||
| |||
Keywords: TechHelp Access rounding errors, math errors, errors calculating commission, .000000000000001 problem with doubles, for next step PermaLink Fixing Rounding Errors in Microsoft Access |