======= Date Modified 27 Jan 2011 17:35:03 =======
:-( so sad, need some help calculating age in months in an access 2007 database, if poss id like to have the age field in the table, showing age in months/years (This is a table containing children's data so will be from age 10 months to 3 years).
Ive tried several formulas such as datediff and /365.25 etc but none of them work when I put them into my database. Im away from my desk so can't put the full code in here but have trawled several online forums and nothing works!
Ive tried doing it as a query also and that hasn't worked either. Any ideas Help :p? :-)

I went on a course last year and we learned how to do it in VBA Access, I remember it wasn't that straightforward to do.