I have a form in which Date of Birth is being entered in DOB field. There is another Field/column in the Form i.e. Age in which I want Date difference in Years, Months and Days to be displayed automatically in Age Field as soon as Date of Birth is entered. For eg. Date of Birth is 24/11/1975 and I want date difference on a particular date say 31/01/2009 for all employees. This was easy in Excel by using formula DATEDIF. How could I do the same in MS Access 2000 or 2007. Alternatively, in Query or Report also it can be used. I have recruitment table of 10,000 candidates and doing it manually will take a lot of time. Please help.