In this video, we will walk you through the process of calculating age by subtracting the date of birth from the current date, and then dividing the result by 365.25. The 'Int' function is used to round off the resulting decimal number to the nearest whole number
AGE: Int((Date()-[DateOfBirth])/ 365.25
If you found this video helpful, please like, comment, and subscribe to our channel for more MS Access tutorials. Thank you for watching, and we'll see you in the next video!
Негізгі бет How to Calculate Age Using a Date of Birth IN MS ACCESS QUERY
Пікірлер: 10