Haven’t seen this one before – I’m getting an error stating “Number of bytes of a UNICODE string is not even” when attempting to run a query in Access.

INSERT INTO tbl_ARCHIVE SELECT tbl_Ret.*, #12/31/2020# as ArchivedDate FROM tmpRet INNER JOIN tbl_Ret ON tmpRet.ID = tbl_Ret.RetID

I have several queries exactly like this for other tables and they have all run successfully, however, this one it causing issues. Any help is greatly appreciated.