Chazelle Consulting Services  

 

Your Microsoft Access Specialists  

Home
Resources
References
Contact us




 
 Calculating Someone's Age
 

To calculate someone's age, use this formula in a text control or in a query


Age: DateDiff("yyyy",[StaffDOB],Now())+Int(Format(Now(),"mmdd")<Format([StaffDOB],"mmdd"))