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
Code:
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:
Code:
?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