Auto populate a date, based on information already entered.

[Dan_Maguire]

Hi Guys.

I'm looking for some support with Microsoft Access - I am in the process of creating a database for a friend, but I have come up against a complication which I don't appear to have had to do before.

My friend is looking for the database to auto populate a date, based on information already entered.

So, this is the situation.

A Learner Starts his/her private tuition lessons on dd/mm/yyyy and pays for 6 weeks, the next lot of payments is due on dd/mm/yyyy...

I am confused on how I can do this? Can anyone help? Really Appreciate it.



Regards, Dan

[ssanfu]

Welcome to the forum....

I would use the DateAdd() function...