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 EXTENDED CUT MEMBERS...  

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

LEARN MORE:
https://599cd.com/Round

LINKS:
Calculated Fields: https://599cd.com/Calculated

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

OTHER COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

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:
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:
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.