ACCESS 07 age calculation display

By kelliedortonsmith ·
I have Access 07 table with DOB field. I created a query with 1 field that calculates a persons age in years and 2nd field that shows age in months.
Code in the query fields are:

Year: DateDiff("yyyy",[DOB],Now()) Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))
Mth: DateDiff("m",[DOB],Now()) Int(Format(Now(),"m")>Format([DOB],"m"))

Id like to have a single field that shows any age under 1 year as months then anything over 12 mths would show up in years.
I have no clue how tho get the results

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums