Calculations as a default value?????

[lucyh]

Hiya - I have a table and in it there are two fields. One is called Direct Cost and the other is called Charge Out. I want the charge out field to have a default value which is basically the direct cost / 80*100.

Can this be done? I have tried all different ways of inputting this and I get the message "Type Mismatch".

Probably an easy one for you guys but I have only just started to venture into the world of calculations in Access!! :o)

[dsatino]

You can't set references to other fields in the default value property.

You can code something to mimic that effect if you're comfortable with VBA though.