Name - Text
Location - Text
Ddate - Date/Time (Medium Date)
Day - Text
The sad part is there is no primary/autonumber in the table.
Situation is something, this database is like 2 years old and the data is being regularly updated. The day column has been recently inserted. Now what we want is to update all the day to weekday names according to the Ddate.