Adding years to date in Table

[Mister-B]

I'm really new to acces but have worked a lot with Excel. I have an access table with lots of Information. In one colum are the dates of birth of employees. I would like Access to now compute the date the employees reach their 60th birthdays. I have tried DateAdd, DateSerial but nothing works. So, I am trying to add 60 years to the date that is in the column named "Geburt". Can anybody help?

[ranman256]

DateAdd("yyyy",60,[Geburt])

[Mister-B]

Thanks for the quick Reply. I have actually tried that before but Access is telling me that it does not recognize "Geburt" although it is definitely the Name of the column in the table. Any ideas?

[Minty]

Where are you trying this ? Open the query designer add your table and then add a calculated field ;

When60: DateAdd("yyyy",60,[Geburt])