Rounding Numbers in Microsoft Access. Understanding Int, Fix, Round, and Banker's Rounding

In this video, I'm going to teach you all about rounding in Microsoft Access. We'll look at the Round, Int, and Fix functions and how they're different. We'll learn about Banker's Rounding. Then, we'll see how to round a number to the nearest interval (5, 10, 100, etc.)
Phillis from Winnipeg, Manitoba, Canada (A Silver Member) asks: I need to calculate a commission rate based on monthly sales. The rate is based on whole dollar amounts only, and we chop off any cents. I know about the Round function, but I don't ever want to round up. How can I do this?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to take some of these complex functions and turn them into global VBA functions. We'll make a function called RoundUp to round a number up to the nearest integer. RoundTo will round to the nearest interval (10, 100, etc.). Finally, we'll make a SchoolRound function which rounds the way you were taught in high school, where 1-4 rounds down and 5-9 always rounds up.
MEMBERS VIDEO:
• Rounding Numbers EXTEN...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Round
LINKS:
Calculated Fields: 599cd.com/Calc...
SUGGESTED COURSE:
Access Expert 8: 599cd.com/ACX8
OTHER COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, round, int, fix, bankers, Rounding numbers in Access, ms access round to 2 decimal places, nearest penny, nearest dollar, round up, round down, positive, negative, towards zero, away from zero, infinity, bias, nearest 5, nearest 10, nearest 100
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@VerdeTraks]

Phyllis is wild, scraping all those fractional cents for company profits 😂

[@ashishtrivedi8253]

Great help! Thx.

[@599CD]

You bet!

[@angelakavanagh2813]

Hi, I have watched Rounding Video but not sure any of those scenarios quite sort my little problem. I want to list show in a report... 1) retail price 2) 65% of retail price 3) 35% of retail price. It does the penny out thing. Maybe the 35% field in my query should be a formula to say "Retail Price field" less "To Ang field"? Whatever I try entering in the query isn't valid. I will try to upload a couple of snips to make more sense. Thank you Oh dear, I can't see where to put the pics. I'll have to watch your video on that again! I don't see an Upload Images link top right?

[@599CD]

The upload images thing is on my web site, not on KZbin. I see what you're saying about the rounding problem. I've got a video coming out that actually addresses this soon. Hang in there.

[@lucky4you311]

between dates

[@599CD]

Huh?

[@lucky4you311]

@@599CD boss between dates apply round