calculate age using queries

[ariel81]

i have a table with fields "[DATE OF BIRTH]", "age", "temp-age"

i have a query that calculate the age:
example; the query will get user to input the "temp-age" and upon "temp-age" is input and "ok" on the query, it will calculate a person's age and store the value inside table "age".

however, the calculated value for the age have some data problem. for example, when a person whose age is yy:mm 24:05 the age inside the table will be 1924:05. there will be a additional "19" at the age.

what cause the additional "19" problem?
---------------------------------------------------------------------
my query in design view is like this; (see attachment)
it uses " [temp-AGE]-[DATE OF BIRTH] " to calculate the age and store into table "age".

 

[RuralGuy]

Maybe this link will help clear up some of your questions. I have to ask: Age is one of those elements that changes *every* second so why would you want to store this calculation?