INSERT INTO tblLabels ( [Факт# ЕД], GTIN, Batch, ProductionDate, ExpirationDate, [SumOfФакт# ЕД], [№ заказа], КоличествоВКоробе, [cust-desc], GrossWeight, NetWeight, КолвоЭтикеток, ArticleMetro, Description, Наимнование )
SELECT qrRep1733.[Факт# ЕД], tblArticle.[adal-alias] AS GTIN, qrRep1733.Партия AS Batch, IIf(IsNull([qrRep1733].[Дата изготовления])=False,Format(CDate([qrRep1733].[Дата изготовления]),"dd/mm/yyyy"),"") AS ProductionDate, IIf(IsNull([qrRep1733].[BBD - МСГ])=False,Format(CDate([qrRep1733].[BBD - МСГ]),"dd/mm/yyyy"),"") AS ExpirationDate, Sum(qrRep1733.[Факт# ЕД]) AS [SumOfФакт# ЕД], qrRep1733.[№ заказа], tblArticle.КоличествоВКоробе, tblArticle.[cust-desc], tblArticle.GrossWeight, tblArticle.NetWeight, 0 AS КолвоЭтикеток, tblArticleMetro.ArticleMetro, tblArticleMetro.Description, "(" & [tblArticleMetro].[ArticleMetro] & ") " & [tblArticleMetro].[Description] AS Наимнование
FROM (qrRep1733 INNER JOIN tblArticle ON qrRep1733.cWrin = tblArticle.Wrin) INNER JOIN tblArticleMetro ON tblArticle.ArticleCustomer = tblArticleMetro.ArticleCustomer
GROUP BY qrRep1733.[Факт# ЕД], tblArticle.[adal-alias], qrRep1733.Партия, IIf(IsNull([qrRep1733].[Дата изготовления])=False,Format(CDate([qrRep1733].[Дата изготовления]),"dd/mm/yyyy"),""), IIf(IsNull([qrRep1733].[BBD - МСГ])=False,Format(CDate([qrRep1733].[BBD - МСГ]),"dd/mm/yyyy"),""), qrRep1733.[№ заказа], tblArticle.КоличествоВКоробе, tblArticle.[cust-desc], tblArticle.GrossWeight, tblArticle.NetWeight, 0, tblArticleMetro.ArticleMetro, tblArticleMetro.Description, "(" & [tblArticleMetro].[ArticleMetro] & ") " & [tblArticleMetro].[Description];