N
Nancy
I have seen the responses to the calculating ages questions and see that Tom
Lake's response to Todd does work. However, I need to produce the child's
age in years and months. The db is for a child care center where the more
exact age is needed. I do not want the age in months only because the user
then must manually divide to figure out the age of a child -- 49 months is 4
yrs/1 mos. Nor do I want to use a decimal approach because there are 12
months in a year. Must I use 2 fields and calculate separately? If so what
is the formula to show only the remainder months? I'd rather have one field
if possible.
Lake's response to Todd does work. However, I need to produce the child's
age in years and months. The db is for a child care center where the more
exact age is needed. I do not want the age in months only because the user
then must manually divide to figure out the age of a child -- 49 months is 4
yrs/1 mos. Nor do I want to use a decimal approach because there are 12
months in a year. Must I use 2 fields and calculate separately? If so what
is the formula to show only the remainder months? I'd rather have one field
if possible.