Tables and reports

P

Pete

I am setting up a database for work that tracks all of our personnels
information (personal, training, etc.). I have set everything up in forms and
I have boxes that calculate certain due dates for training. For example I
have a box that says "Annual Trainging Completed" in which I type in the
date; then I have another box that says "Annual Training Due" and it
calculates one year out. Unfortianately it doesnt place the calculated date
in the tables and I cannot set up a report to show the due dates for our
emplyees. Any halp will be greatly appreciated.

Thanks
 
V

Van T. Dinh

You can include a Calculated Field "Training Due" in the Query being used as
the RecordSource for the Report and use the same expression as you use in
the Form to re-calculate the [Training Due] from the [Training Completed].
 
K

Klatuu

I agree with Van. One of the Database 10 commandments is
Thou shalt not store calculated values.
There are numerous reasons for this.
All you need to do is:
=DateAdd("yyyy",1,LastTrainingDate)
As Van said, use this in your form to display the date. The best place is
probably the Current event of the form. Use the same function on the report
to display it.
 
Top