Calculated Info is not being recorded in the table.

[Shnake]

Hi,

Newbie question...or maybe OLDBIE question...I have not done any work in access since Windows 95 so I'm a bit crusty.

I'm trying to help out the misses and have put together a Db for her but I'm having a problem.

She would like the dates that people are eligible for insurance to be automatically generated based on the persons Employee Start date. This calculation is also contingent upon the person being either a FT Salary employee or a FT Hourly wage employee.

The problem I'm having is that the calculations from the form are not being saved in the table. How do I accomplish this?

Here is the calculation I am using.
=IIf([FT_Hourly] Or [FT_Salary],DateAdd("d",60,[Dateofhire]),Null)


Thank you

[Seth Schrock]

If this date doesn't change, then the best thing would be to have this date calculated in a query (per normalization rules, calculated fields should never be stored). If this is more like a default value, then this is fine.

Where do you have this calculation?

[Shnake]

It will not change.

The calculation is in the form field part of expression builder.

[Seth Schrock]

Since it won't change, then create a calculated field in a query with all the other fields that you need and then bind the form to that query. To keep from getting error message if someone tries to edit the value, I would set the Locked property of the textbox bound to this field to True.

[Shnake]

Ok I will try to figure out exactly how to do that...

Thanks a bunch...

[Shnake]

If it where a default value how would I do that?

[Seth Schrock]

Just put the formula that you posted in the OP in the Default Value property of your control

[Shnake]

OK Just Checked with the Misses...this is a DEFAULT value...how can I have that work?

[Seth Schrock]

Just as I described in post #7. However, you wouldn't do the query method.