Software

Ask something
Discussion Locked

DOB & AGE using Access

0 helpful
1 reply

by robert_funches1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I use Access to for DOB (Date of Birth) in one column and have in another the current age shown. What is the formula and were is it placed in Access.

1 reply

by glen_mcleod

You can't have calculated fields in Access tables, but you can us a query to get the result you want.

Select DOB, Fix(DateDiff("m",#13/08/1966#, Now())/12) as Age
From YourTable
Where...

This will give you your DOB field and a calculated Agefield.

Fix() simply drops any decimals values, as opposed to CInt() that rounds them.

Glen

This discussion is closed to new replies.