General discussion
October 10, 2003 at 02:45 PM
pudney

Access formula required

by pudney . Updated 22 years, 11 months ago

I have created an Access client database which has a field for “date of birth”. How do I get Access to calculate in another field the actual age? I have used the following expression but it does not seem to work.
Int((Date()-[Client]![Client-DOB])/365)
Many thanks

This discussion is locked

All Comments