hey guys,

just wondering if someone could give me a formula/function for calulating peoples age in a query, at a particular date. I have a DOB field, and need to add in these age field in the query.

I have come across this formula:

DateDiff("yyyy" , [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

But I need one where I can...