working out years

[rhann]

I have a date in a table on a form I want to be able to work out how many
years have passed since that date, also if it is possible can it be done in a
table

 

[Duane Hookom]

There is code and an expression at
http://www.mvps.org/access/datetime/date0001.htm to calculate age. You don't
want to store calculated values in tables.

 

[Larry Daugherty]

It cannot be done in a table. Tables are just containers. There is
no active code in them.

Look in Access Help for DateAdd

HTH