How do you caculate the exact age of an individual based on their birthdate in access?

Relating to so a long way tried to used this expressions beneath to calculate age a person based on their start date but are already having issues with using these.The following expression is effective but only bases the age on all seasons and not really the month, the primary expression would seem better although I can’t get it to do the job.If anyone could convey to me tips on how to enter any function towards access that may calculate age exactly that would have been a great guide!

In case Month(DateToday) < Month(Bdate) And also (Month(DateToday) = Month(Bdate) And Day(DateToday) < Day(Bdate)) And then Age = Year(DateToday) – Year(Bdate) :1 Altogether different Age = Year(DateToday) :Year(Bdate)

Plus:
DateDiff(“yyyy”, DateofBirth, Date())

You may possibly try simply finding the difference concerning DateofBirth plus Date() inside *days* certainly not years, plus divide by by 365.25

DateDiff(“d”, DateofBirth, Date()) / 365.25

Using these services might possibly be incorrect per day or a couple before/after the birthday, but really should be very nearby.

Would you like something more accurate, check out this VB purpose:

http://allenbrowne.com/func-08.code.