One way would be to copy the records manually and paste append them. Assuming you're using an autonumber field, then update the date to your 2024 date WHERE myIdField > whatever your last number was before the append. Copy and paste append can be wonky sometimes so I'd suggest copying the table first so that you have a backup of it.
Of course, there are more complicated methods such as writing code to
- copy the recordset and append the new records with the 2024 date using .AddNew, or
- write a sql statement that loops over a recordset and runs an update sql statement that makes use of the new date
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.