Updating age based on date of birth

[Luis Lebron]

I have a table that contains a date of birth (date) and a age field. How can
I create an update query that would calculate the correct age (from the date
of birth) and update the age field? I tried doing it with php but ran into
problems with persons born before 1969.


thanks,

Luis R. Lebron
Sigmatech, Inc