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;