Adding dates

[Johnboy]

Hi All,

Kind of new to access please bear with me. In my table I have 5 fields that are date formatted, I need to have the date auto filled when first date field is inputted the next date field will will add 30 days. This will continue for the remaining fields. In Excel this is simply done with "=A2+30".

Thank you for your time.
Johnboy

 

[Joe4]

I think you should be able to do what you want with an update query. Check out Access help on "Create an update query" for directions on how to do this.