I am appending records to an archive and want to assign the current date to a [Date_Archive] in the archive table.
Here is the append:
Insert Into Import_FC_Archive
I am executing this saved append query like so:
Private Sub cmdImport_Click()
(I have a docmd transferspreadsheet after this) - typing from phone