If that's your table:
[pre]
ID (AutoNumber) DateField Field1 Field2 Field3
1 1/1/2020 ABCD XYZ 765
2 2/2/2022 JHgy Hgb 123
3 3/3/2023 jhgg hgT 987
[/pre]
And you want to Copy record with ID = 2, I would try:
[tt]
INSERT INTO MyTable (DateField, Field1, Field2, Field3)
SELECT Date(), NULL, NULL, Field3 FROM MyTable Where ID = 2
[/tt]
Assuming Field1 and Field2 will accept NULLs, what you consider to be blank
(Not tested)
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson