Field within same table that updates

[Strugglin]

Hello All!

First off, newbie here and many thanks for offering such a forum.

Second off, Access newbie (well sort of) beyond the wizards.

What I'm trying to do is within my Customer table I have an ActivationDate and DeadlineDate field which I need to automate 14 days from the AD field to the DD field. Effort to figure this out has been taken with no smily face results. Could someone tell me what and where please?

Thanks in advance.

 

[Mile-O]

I tried to set it up at table level but had no luck so the quickest way would seem to be to use an Update Query with the criteria written using the DateAdd() function.

 

[Rich]

Problem is that you're storing what is in effect a calculated field, you should use a query/ calculated control to display this date and remove the field from your table

 

[Strugglin]

Thanks for heading me in the right direction. I solved the problem with the DateAdd function inserting this formula into the form field of my DeadlineDate:

=DateAdd("d", 14, [ActivationDate])

Works like a charm! Appreciate you folks responding to my now solved dilemna.