CALCULATING FUTURE DATE

[okschlaps]

Does Access have a function similar to SQL's ADD_MONTHS? I want to set a date
field based on an date entry in another field times the number of years in a
third field. Thanks

 

[Rick B]

Yes, use the DATEADD function. The help files will give you all the
parameters.

 

[Ofer]

check help on function called DateAdd, you can add to a specific date houres,
days, month, etc

DateAdd("yyyy",[AmountOfYearsFieldName],[DateFieldName])

Add years to the date field