Форумы HiProg.com - MS ACCESS, VBA, VB

ник: osmor
так?

SELECT CAODealRegs.RegNumber, CAODocs.DocDate, Sum(CAOGiveGoods.Price) AS [Sum-Price]
FROM (CAODealRegs LEFT JOIN CAODocs ON CAODealRegs.ID = CAODocs.DealReg) LEFT JOIN CAOGiveGoods ON CAODocs.ID = CAOGiveGoods.DocID
GROUP BY CAODealRegs.RegNumber, CAODocs.DocDate
HAVING (((CAODocs.DocDate) Like "*2008*") AND ((Sum(CAOGiveGoods.Price)) Is Not Null And (Sum(CAOGiveGoods.Price))<>0))
ORDER BY CAODocs.DocDate DESC
UNION SELECT "ИТОГО:",Null,Sum(CAOGiveGoods.Price) AS [Sum-Price]
FROM CAOGiveGoods INNER JOIN CAODocs ON CAOGiveGoods.DocID = CAODocs.ID where (CAODocs.DocDate Like "*2008*") ;