Software

Ask something
Discussion Locked

Access XP

0 helpful
7 replies

by robert_funches1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have the formulas for Age(). But need help in were are they installed in the colums DOB and AGE

7 replies

by kees.valkenswaard

You should clarify what you really want. Do you want to add AGE to a table? I would not recommend this, as next year all your ages are wrong.
Do you want to add it to a query? In that case just an additional field with your formula would do.
Or doyou need a form with the age shown somewhere. In that case add a text box with the formula added to the box [always including the = sign at the start]
Good luck.

by kees.valkenswaard

Suppose you have a field DoB as date field in which the date of birth is entered.
In a query [made with the query builder] add also a field in which you enter in the box field:

Age: Year(Date())-Year([DoB])-IIf(Month(Date())

This discussion is closed to new replies.