Calculating Age In Access

Do NOT store the age as a calculated field in the table. People age one day at a time (heck, we age an hour at a time, a minute at a time). In that sense, we are never the same age from the moment we're born. The only time you could calculate an age reliably would be "age at death", or some other specific "As Of" date.

Rather, use that function to calculate the age in a query and DISPLAY it as needed. You can DISPLAY it in a control on a form or a report as well, using that calculation.

I see this is the same relational database application as in your other thread on table design. I should have picked upon the name field problem in answering it, but let's address it here.

It's important to resolve names into the smallest data points feasible. Here, at a minimum that would be FirstName and LastName, probably also MiddleName since there are artists like Jerry Lee Lewis who use all three....

here is another function:

Function fnAge(dtmBD As Variant, Optional dtmDate As Variant = 1) _
As Variant
' Calculate a person's age, given the person's birth date and
' an optional "current" date.
If IsNull(dtmBD) Or Not (IsDate(dtmBD)) Then
Exit Function
End If
If IsNull(dtmDate) Then dtmDate = 1
If dtmDate = 1 Then
' Did the caller pass in a date? If not, use
' the current date.
dtmDate = Date
End If
fnAge = DateDiff("yyyy", dtmBD, dtmDate) + _
(dtmDate < DateSerial(Year(dtmDate), Month(dtmBD), _
Day(dtmBD)))
End Function

you create a Query against your table:

select artist_id, artist_name, birth, death, fnAge([Birth], [Death]) As Age from yourTableName;