automatically add months to date entered in another field

[Guest]

How do I set my computer to automatically add 6months to the date entered in
one field and post it in another. For example: I enter todays date in column
1 and I want it to automatically enter the date 6months later in column 2.

 

[Allen Browne]

Use:
DateAdd("m", 6, [NameOfFirstFieldHere])

There are 2 approaches you could use:
a) Just get Access to calculate this for you, so it can never be wrong.
b) Store the value, so that it doesn't have to remain 6 months from the
other date.

For details on when and how to use those 2 approaches, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[Rick B]

You don't. That would be redundant. When you need that calculation, simply
calculate it. You don't store calculated values in a table. What if the
"first date" changes? What would prompt the second date to update?