SELECT dbo_ncards_vwDSE.id, dbo_ncards_vwDSE.blank, dbo_ncards_vwDSE.name, dbo_ncards_vwDSE.PathDesign, dbo_ncards_vwDSE.Remark, dbo_ncards_vwDSE.Izd, dbo_ncards_vwDSE.rblank, dbo_ncards_vwDSE.RemarkName, dbo_ncards_vwDSE.RemarkType, dbo_ncards_vwDSE.size, dbo_ncards_vwDSE.size1, Date() AS date_upd INTO tmp2
FROM base RIGHT JOIN dbo_ncards_vwDSE ON base.blank = dbo_ncards_vwDSE.blank
GROUP BY dbo_ncards_vwDSE.id, dbo_ncards_vwDSE.blank, dbo_ncards_vwDSE.name, dbo_ncards_vwDSE.PathDesign, dbo_ncards_vwDSE.Remark, dbo_ncards_vwDSE.Izd, dbo_ncards_vwDSE.rblank, dbo_ncards_vwDSE.RemarkName, dbo_ncards_vwDSE.RemarkType, dbo_ncards_vwDSE.size, dbo_ncards_vwDSE.size1, Date(), base.blank
HAVING (((base.blank) Is Null));

INSERT INTO base
SELECT *
FROM tmp2;

SELECT base.id, base.blank, base.name, base.PathDesign, base.Remark, base.Izd, base.rblank, base.RemarkName, base.RemarkType, base.size, base.size1, base.date_upd INTO base_tmp
FROM base
GROUP BY base.id, base.blank, base.name, base.PathDesign, base.Remark, base.Izd, base.rblank, base.RemarkName, base.RemarkType, base.size, base.size1, base.date_upd
HAVING (((base.date_upd)=Max([base]![date_upd])));

SELECT Date() AS date_upd, dbo_ncards_vwDSE.id, dbo_ncards_vwDSE.blank, dbo_ncards_vwDSE.name, dbo_ncards_vwDSE.PathDesign, dbo_ncards_vwDSE.Remark, dbo_ncards_vwDSE.Izd, dbo_ncards_vwDSE.rblank, dbo_ncards_vwDSE.RemarkName, dbo_ncards_vwDSE.RemarkType, dbo_ncards_vwDSE.size, dbo_ncards_vwDSE.size1 INTO tmp
FROM base_tmp LEFT JOIN dbo_ncards_vwDSE ON base_tmp.[blank] = dbo_ncards_vwDSE.[blank]
WHERE (((base_tmp.PathDesign)<>dbo_ncards_vwDSE!PathDesign)) Or (((base_tmp.size1)<>dbo_ncards_vwDSE!size1));

SELECT dbo_ncards_vwDSE.blank, base_tmp.PathDesign AS Маршрут_был, dbo_ncards_vwDSE.PathDesign AS Маршрут_стал, base_tmp.size1 AS Заготовка_была, dbo_ncards_vwDSE.size1 AS Заготовка_стала
FROM base_tmp LEFT JOIN dbo_ncards_vwDSE ON base_tmp.blank = dbo_ncards_vwDSE.blank
GROUP BY dbo_ncards_vwDSE.blank, base_tmp.PathDesign, dbo_ncards_vwDSE.PathDesign, base_tmp.size1, dbo_ncards_vwDSE.size1
HAVING (((base_tmp.PathDesign)<>[dbo_ncards_vwDSE]![PathDesign])) OR (((base_tmp.size1)<>[dbo_ncards_vwDSE]![size1]));

INSERT INTO base
SELECT *
FROM tmp;