Adding years

[Kosmos]

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.

[ADezii]

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])

[Kosmos]

'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])

Ahh my mistake...it is adding it to a table
So I would do something like recSet7.Fields("Date") = DateAdd("yyyy", recSet7.Fields("Years"), recSet7.Fields("Date") ?

[Kosmos]

This actually should work. Thanks! :)