SELECT tblSkl.NazivSkl, tblStavke.NSN, tblMS.NazivBH, tblSJM.SkNaziv, SUM(tblStavke.Klc) AS Koli

ina, tblVrDoc.VriP, SUM([Klc]*[VriP]) AS Stanje

FROM tblVrDoc INNER JOIN (tblSJM INNER JOIN (tblMS INNER JOIN (tblSkl INNER JOIN (tblDoc INNER JOIN tblStavke ON tblDoc.BrD = tblStavke.BrD) ON tblSkl.SSkl = tblDoc.SSkl) ON tblMS.NSN = tblStavke.NSN) ON tblSJM.SJM = tblMS.SJM) ON tblVrDoc.VrDoc = tblDoc.VrDoc

WHERE tblDoc.DatDPos BETWEEN [PocetniDatum] AND [KrajnjiDatum]

GROUP BY tblSkl.NazivSkl, tblStavke.NSN, tblMS.NazivBH, tblSJM.SkNaziv, tblVrDoc.VriP;