Saving calculated due dates to the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get the calculated due dates from a form to save in the table? The
form currently calculates the due date based on the referral date; however,
this date does not transfer back to the table. The calculated due date will
not change and I need this information to transfer back to the table in order
to run a tickler report. Thanks for any help offered.
 
How do I get the calculated due dates from a form to save in the table? The
form currently calculates the due date based on the referral date; however,
this date does not transfer back to the table. The calculated due date will
not change and I need this information to transfer back to the table in order
to run a tickler report. Thanks for any help offered.
Click to expand...

No, you don't need to save the due date.
As long as you have the referral date saved, any time you need to
calculate the due date, calculate it, in a query, on a form or in a
report, using the same expression you are now using.
 
How do I get the calculated due dates from a form to save in the table? The
form currently calculates the due date based on the referral date; however,
this date does not transfer back to the table. The calculated due date will
not change and I need this information to transfer back to the table in order
to run a tickler report. Thanks for any help offered.
Click to expand...

If you can calculate it on the Form, you can calculate it in exactly
the same way, just as easily, on the tickler report. There's no need
to save it.

John W. Vinson[MVP]
 
Back
Top