Access Default Filed equals another field in the same table

[gheyman]

I want a field in my table to default to the value of another field if the other field has a value. I cant find how to do this.

Thanks

 

[Joe4]

That is not proper design in an Access database. All table fields are supposed to be independent on each other.
The sort of dependency you are talking about would really be a calculated field in a query, not a table field.
If you control all data entry through Forms, you could use VBA code to set the value of that field at time of entry, and could base it on the value of other fields (provided that field already has data).