Auto update student's age

[raywhite]

NEWBY. I am very new to Access and I am creating a database for a children's home we run.
It will contain details of all the children.
I would like to be able to have a place where I input their date of birth and another field where the database automatically tells me their age and yet another field where the database automatically tells me when they will turn 18 years old.
Can I do this and if so how?
naturally there will also be a lot of other fields such as name, gender, date admitted, school class etc. I think those should be fairly simple but the date / age / turns 18 on have me lost.
Any help much appreciated
Thanks

[June7]

Calculate age in query, don't store in table. Same for the 18th birthday.

Calculating age is not as simple as might think. Review http://access.mvps.org/access/datetime/date0001.htm

[raywhite]

Calculate age in query, don't store in table. Same for the 18th birthday.

Calculating age is not as simple as might think. Review http://access.mvps.org/access/datetime/date0001.htm

Thank you for your really helpful reply. No wonder it had me baffled. I feel sure that by following the info in the link you kindly provided I will manage.
Much appreciated.

[isladogs]

Agree with June. Using an Age function to calculate Age in a query as needed.
There are many different Age functions, some more complex than others.
The one I use is probably the the most concise

Function AgeYears(datDate1 As Date, datDate2 As Date) As Integer
    AgeYears = DateDiff("yyyy", datDate1, datDate2) + (Format(datDate1, "mmdd") > Format(datDate2, "mmdd"))
End Function

Normally datDate1 would be the date of birth & datDate2 would be today's date so use the Date function for that. For example, someone born on 15 May 1982:

?AgeYears(#5/15/1982#,Date())
38

If you want to read a lengthy discussion/argument on various approaches to calculating age, see https://bytes.com/topic/access/answe...invalid-syntax

[raywhite]

Thank you that is helpful

Agree with June. Using an Age function to calculate Age in a query as needed.
There are many different Age functions, some more complex than others.
The one I use is probably the the most concise

Function AgeYears(datDate1 As Date, datDate2 As Date) As Integer
    AgeYears = DateDiff("yyyy", datDate1, datDate2) + (Format(datDate1, "mmdd") > Format(datDate2, "mmdd"))
End Function

Normally datDate1 would be the date of birth & datDate2 would be today's date so use the Date function for that. For example, someone born on 15 May 1982:

?AgeYears(#5/15/1982#,Date())
38

If you want to read a lengthy discussion/argument on various approaches to calculating age, see https://bytes.com/topic/access/answe...invalid-syntax

[pbaldy]

Post 5 was moderated, I'm posting to trigger email notifications.