Date computation

  • Thread starter Thread starter JLALLMER
  • Start date Start date
J

JLALLMER

How do i have a computed futureddate in a table.

Want to enter a date then compute a future date 60 days later and have the
computed future date save to a table.

I easily compute and see the computed date in what I call an input form,
however that only computes the futuredate in thte form, it will not place the
futuredate into the table for later retreival in a report. The future date
in the table remains blank.
 
Hi,
Don't try to save the computed future date in a table.
When you want to run the report, base the report on a query.
In the query add a calculated field that computes the future date.

Jeanette Cunningham
 
How do i have a computed futureddate in a table.

Want to enter a date then compute a future date 60 days later and have the
computed future date save to a table.

I easily compute and see the computed date in what I call an input form,
however that only computes the futuredate in thte form, it will not place the
futuredate into the table for later retreival in a report. The future date
in the table remains blank.
Click to expand...

Do not store computed data.
Anytime you need to see the future date, computed it as you seem to be
now doing on your form.
 
I easily compute and see the computed date in what I call an input form,
however that only computes the futuredate in thte form, it will not place the
futuredate into the table for later retreival in a report. The future date
in the table remains blank.
Click to expand...

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

John W. Vinson [MVP]
 
Back
Top