|
||||||
|
Age, Part 2 By Richard Rost 3 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. MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
Links
Keywordsmicrosoft 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
|
||||||||||||||||||||
| |||
Keywords: TechHelp Access calculating age part 2, age in access, 100% accurate age in microsoft access, datediff, dateserial PermaLink Age, Part 2 in Microsoft Access |