Default Values

[JeepsR4Mud]

I'm doing a table regarding employee hiring and evaluation.

I have 2 fields:

Last Promotion Date

Last Evaluation Date

I want the defalut value for Last Evaluation Date to be Last Promotion Date. Is that possible? I keep getting an error message when I am in the table design view, which says it doesn't recognize the field.

Thanks.

Gayle Ann

 

[FoFa]

Default value on a table occurs when you INSERT (append) a record and that field is NULL, then it populates it with the default value. Basing the default value on another field in the table would seem to serve no purpose as they would be both NULL when insert happens until there is data in the row, I think you need to handle that in a form doing the actual insert.

 

[JeepsR4Mud]

Actually, they are not both null. I have a date in the first field and need for it to be the default in the second field. After the person completes probation a new value is enterd in the second field. During the first 60 days I need a default for the query to work. Is it possible to use a field as the default value for another field within the same table?

 

[Pat Hartman]

No. You'll have to do this with the form you use to enter the data.