Age, Part 2
By Richard Rost 2 years ago
Checking the Accuracy of Original Age Calculations
In this video, we will examine the Age calculations in my original Microsoft Access Age video and see just how accurate they are. I built a database to run through 10 million date calculation iterations, and it turns out the original formula is 99.91% accurate. I will, however, show you a more advanced formula that is always 100% accurate.
Rabid Follower (a YouTube Subscriber) says: I think dividing by 365.2524 could lead to erroneous results pretty often, and it's not "1 in 5000" like you said... It’s more like 1 in 486 from my calculation.
Members will see exactly how I built my database to perform my calculations to check my accuracy.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, calculating age part 2, age in access, 100% accurate age in microsoft access, datediff, dateserial
Subscribe to Age, Part 2
Get notifications when this page is updated