Reply to Message

in your access aplication.
If so just adapt the provided solution.
ie detect the the date has changed and insert a record in to another table with the data you need.

If it can be changed from 'anywhere' then you are SOL and need to pick a proper DBMS that implements triggers as your backend. e.g. SQL Server.

Or you change your schema and take DateAttend out of whereever it is and have an AttendanceDates Table, which might make more sense.