Automatic Updates

Kitty_Kitty

New member
Local time
Today, 14:11
Joined
Oct 23, 2006
Messages
3
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
 
subscription date

Use the DateAdd function

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

This will add one year to the [datetoincrease] field
 

Users who are viewing this thread

Back
Top Bottom