Calculated Info is not being recorded in the table.

[JTKrol]

I am using the below calculation in a form field but it is not getting recorded to the field in the table.



I am taking the person's date of hire and weather they are Full Time salary or hourly employees, then adding 60 days to determine eligibility date for Health, Life and Vision insurance.

I then want to populate each field with the calculated date. It work on the form but I'm getting blank fields in the table...

=IIf([FT_Hourly] Or [FT_Salary],DateAdd("d",60,[Dateofhire]),Null)

I'm using the Null because when I used 0 I was getting some funky dates.

Joe

[June7]

Usually, should not save calculated data, calculate when needed. Saving requires code (macro or VBA).