Calculate Date

[Guest]

I have a form based on a table with the fields "Start Date" and "Next Visit
Date". I would like to enter a formula in the "NextVisit Date" field to
calculate the date 3 months from the start date. For example, if I enter a
start date as Jan 1, 2006 in the "Start Date" field I would like the "Next
Visit Date" field to automatically enter the date 3 months from the start
date of Jan 1, 2006 so that I will know when the next visit date should
occur. I am using Access 2003.

Thanks very much for any help.

Best regards,

Dee

 

[Jeff Boyce]

Dee

Just say "no"! It is rare that you'll need to store a calculated value.
And there are downsides to doing so.

It sounds like you already know (i.e., can "calculate") the "NextVisitDate"
if you know the "StartDate" (is it always [StartDate] + 3 months?).

Do this in a query instead of in the table. Use the query to feed your form
(and any reports that need "NextVisitDate".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

As Jeff points out, you should not store this information in a table;
however, if the data is for display purposes only, the formula would be:

DateAdd("m", 3, [Start Date])