I am using Access2000, try it DateDiff does not work.
Say someone is born in May 10, 2000, I want the query to tell me 6 y, 1m, 3 d