Chazelle Consulting Services  

Contact Us

Home  |  Profile  |  Consultants |  References   

 

 

Home
 
Databases
Services
Resources
 
Web Design
Services
Portfolio
 
QuickBooks
Services
 
Office Automation
Services
 
Networking
Services
 
 
 

 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"))
 

 

1