saving calculated fields to table

R

René

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
 
S

Steve Schapel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Structure 11
Table Design - Handling field with a mix of null, fixed and varaiablevalues 9
calculated fields in pivot tables 1
Pivot Table Calculate Field 1
Recommendation for Lookup Table(s) 3
Default Value for a Date 4
Date/Time Field Question 4
Normalizing Tables and Enter Data in Fields Based on Employee Numb 1

Top