Question

Locked

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
Thanks

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums