Automatic Updates

[Kitty_Kitty]

Hi there,

I know very little about Access but been asked to find out if this is possible:

On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?

Thank you very much

Cathy

 

[Rickster57]

subscription date

Use the DateAdd function

DateAdd("yyyy",1,[datetoincrease])

This will add one year to the [datetoincrease] field