Creating a calculated table field

[FNey]

I want to create an Access2010 table field that calculates a persons age from a Date of Birth date field (preferably without using code/query). Anything I've tried (i.e Date of birth minus one of the basic built in date functions, fail). any help would be greatly appreciated. Please be explicit.

[aytee111]

The short answer is - Don't! This is a value that changes every day. Rather create a standard query that calculates age and refer to it whenever you need to display the value.

See here: http://www.fontstuff.com/access/acctut05.htm

[ArviLaanemets]

On fly:

=Year(Date) - Year(Birthday) - Iif(DateSerial(Year(Date),Month(Birthday),Day(Birt hday))>Date,1,0)

(There is a problem with 29. February when birthday is on 29. February, in current year February has 28 days, and current date is 1. March.)

Not that I advise to put it into table