saving calculated fields to table

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

Guest

I have a couple of calculated fields that the values are generated off of one field. They are showing up in the form but are not being transferred to the table.

[Hire Date] is the entry field, [Probationary End Date] is [Hire Date] +90 days,

[Annual Review] is [Hire Date]+1 yr and [Next Review] is [Annual Review] + 1yr

The ultimate would be for the annual review date to default to 1yr after hire, and then be actual after that date.

Help with proper coding for above would be great, but more important is getting the information to store in table
 
René,

Storing these derived values in a table is not necessary, and would in
fact be regarded by many as invalid methodology. Whenever you require
these dates, for your purposes on form or report, they can always be
obtained via very simple queries.

- Steve Schapel, Microsoft Access MVP
 
Back
Top