Software

Ask something
Discussion Locked

Date of Birth=Age

0 helpful
6 replies

by robert_funches1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Using Access, how do I setup the formula to calculate the year your born and in another colume show me your current age. This must update automatically yearly.
MM/DD/YYYY = Age
06/05/1948 = 53

6 replies

by richtee

One way to accomplish this is by creating a query with a field that does the calculation for you. Every time the query is run you will have the current ?age?. You can base reports on this query and it will show the current age in your report automatically. You could also use it for forms.

Assume that the date field you input is called ?dteDOB?. Insert a field in your query grid and put the following formula as the field:

AGE: Int((Date()-[dteDOB])/365.25)

This should almost always (may be off by a day in some cases) give you the exact age difference in years.

Good Luck, Rich

by richtee

For the year you're born, add a field to the query with the following as the field.

YearBor: Year([dteDOB])

This will return just the year of birth.
Rich

This discussion is closed to new replies.