Rounding Numbers in Microsoft Access. Understanding Int, Fix, Round, and Banker's Rounding
9.3 هزار بار بازدید -
2 سال پیش
-
In this video, I'm going
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: 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.
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: 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.
2 سال پیش
در تاریخ 1401/02/29 منتشر شده
است.
9,300
بـار بازدید شده