TRANSFORM Sum(tblCitiProduktiPard.cvDaudzums) AS SumOfcvDaudzums
SELECT Addresses.AddressLine1, tblCitiProdukti.cpProdukts, Sum(tblCitiProduktiPard.cvDaudzums) AS SumOfcvDaudzums1
FROM tblCitiProdukti INNER JOIN (Addresses RIGHT JOIN tblCitiProduktiPard
ON Addresses.AddressID = tblCitiProduktiPard.cvAdrese) ON tblCitiProdukti.cpID = tblCitiProduktiPard.cvProdukts
WHERE (((Addresses.AddressID)=[Forms]![frmAdrTownsCountry]![AddressID]))
GROUP BY Addresses.AddressID, Addresses.AddressLine1, tblCitiProdukti.cpProdukts
ORDER BY Addresses.AddressLine1, tblCitiProdukti.cpProdukts
PIVOT Format([cvDatums], "mmm"  ", "  "yyyy" );