I need to create a trigger to input current date in field when record is updated.
I am working with a front end Access database with linked SQL Server tables.
The field I want to update to current date is Update_Date. Just want the system to automatically update this field with the current date after any field within the record is changed.
How can I write this?