Hints and tips home » Access hints and tips » Create calculated fields that work out your age

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

Added by Meenesh on 5th October 2006

More Access hints and tips, like:

• Relationship maps
• Choosing data types in Access
• remove spaces in a table