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