Access 2000 Table Question

Hi,

Can anyone tell me if there is a way to have a field in a table equal to another field or a part of the field. Say you have a field called "AppDate" in Table1. I want to make a field called "Year" equal to Right([AppDate],4). I want the "Year" field automatically populated when "AppDate" is populated.

Thank you.

If you make AppDate a datetime field, you can then use the Access function

Year(AppDate)

to return the entered year and don't need another firld at all!