Autofill column with age from birthdate

[Ammarhm]

Hi Guys
Please help me with this issue
I am a begginer in access..I have created a form that inputs the Birthdate of a contact into one column in a table, the birth date is input as (YYYYMMDD), I wan a way in access to autofill another column in the same table with the age (as years intiger)
can anyone help me please???

 

[Ammarhm]

autofill column with data

Hi Guys
Please help me with this issue
I am a begginer in access..I have created a form that inputs the Birthdate of a contact into one column in a table, the birth date is input as (YYYYMMDD), I wan a way in access to autofill another column in the same table with the age (as years intiger)
can anyone help me please???

 

[statsman]

Do a search on DateDiff

 

[boblarson]

You should not be entering AGE into the table. That is not accurate as it can change tomorrow. You should just be calculating it on the fly in a query and using that query as your base from which you can do any reporting, etc.

 

[boblarson]

And don't post the same question more than once on the forum. I merged the two together since there were responses in both.