I've got a quick question, I think...I thought it would be simple but suprisingly I can not find a solution so here it goes

I'm trying to find a way that I can add years to a date. I have a field that contains integers that represent a number of years. So, for example, I might have one field that's equal to 2 so that represents 2 years and I'd like to add those 2 years to a date such as 4/15/2006

Any help would be much appreciated. Thanks.

'You did not specify whether you wanted to make this addition in a Table or Form, so I assumed a Form View:

[txtDate] - Field containing the Date to be added to

[txtYears] - Field containing the Integer number of years

[txtNewDate] - Field that will contain the New Date

- Me![txtNewDate] = DateAdd("yyyy", Me![txtYears], Me![txtDate])