I followed your advice (see code bellow). I don't get any error message, query is running but it brings all the data instead of only new recorded data.
Code:
INSERT INTO FullData ( [JOB NUMBER], [PCS#], PCS, [SQ FT], [PRODUCTION DATE] )
SELECT [JOB NUMBER], [PCS#], PCS, [SQ FT], [PRODUCTION DATE]
FROM FromExcelData
WHERE [PRODUCTION DATE]>DMax([PRODUCTION DATE], "FullData");
Also , in WHERE statement should be
Code:
WHERE datefield>DMax([PRODUCTION DATE], "FullData");
or as I did it in the above code?
Thank you