Age with Decimals?

[Lowell]

Is it possible to return an age as: 21.45 or 64.93?



I have done some searching and can't find any formatting or code to make it work.

I have changed the field format to Fixed and then it gives: 21.00 or 64.00

I like the 2 decimal places for quick at-a-glance-knowing of the age.

Of course I have a formula that returns an age with decimals in EXCEL, that's why I think it should somehow be possible in Access.

But I know some say it loud and clear:

Access is not Excel, because Access is superior!

[June7]

You would have to calculate the age in months then divide by 12 to get decimal year.

Access is superior for Relational Data Management. Excel is superior for some other uses.