In MS Access I am wanting to enter a date in a field and then I want it to update another filed automatically with the day of the week in a seperate field.

I then want this field to link with another table so I can run an update query. This database is being used for employees hours, etc and as the team have part time staff this varies day to day.

Any help would be much appreciated.

Many thanks