DateAdd Function Help

[SantasLittleHelper]

Does anybody know the best way to automatically add a date that is 6 months in the future?

e.g. I have a table with a 'Start Date' which is 01/04/16. How can I make the field 'End Date' in the same table automatically update 6 months in advance (01/10/16)?

I have seen a few things online about Update Queries but I am not sure how to do these.

 

[JeanKim]

=EDATE(A1,6)
did you try this?

 

[SantasLittleHelper]

What would A1 refer to in Access?

 

[Norie]

You could use DateAdd in an UPDATE query to do this but you really shouldn't do this in a table.

Let's say you did and new data was added, that would mean you would have to redo the UPDATE query.

Also if, and I know it's probably unlikely, the Start Date was to change in a record you would need to do the calculation again.

Calculations like this really belong in queries.

PS The expression would be EndDate:DateAdd("m", 6, [Start Date]).

 

[JeanKim]

I didn't read this carefully. I thought it was for excel.
Give me a minute for me to test in access

 

[SantasLittleHelper]

The expression would be EndDate:DateAdd("m", 6, [Start Date]).

Thanks, this has worked. Now is there a way of me creating a button that automatically runs the update macro?