SELECT tblDoc.SSkl, tblStavke.NSN, SUM(tblStavke.Klc) AS KolIzlaza

FROM (tblVrDoc INNER JOIN tblDoc ON tblVrDoc.VrDoc = tblDoc.VrDoc) INNER JOIN tblStavke ON tblDoc.BrD = tblStavke.BrD

WHERE (((tblVrDoc.OpisSK)="iz"))

GROUP BY tblDoc.SSkl, tblStavke.NSN;

SELECT tblDoc.SSkl, tblStavke.NSN, SUM(tblStavke.Klc) AS KolUlaza

FROM (tblVrDoc INNER JOIN tblDoc ON tblVrDoc.VrDoc = tblDoc.VrDoc) INNER JOIN tblStavke ON tblDoc.BrD = tblStavke.BrD

WHERE (((tblVrDoc.OpisSK)="ul"))

GROUP BY tblDoc.SSkl, tblStavke.NSN;

SELECT Q_Izlaz.SSkl, Q_Izlaz.NSN, IIf([kolUlaza]=NULL,[kolizlaza],[KolUlaza]-[KolIzlaza]) AS Stanje

FROM Q_Izlaz INNER JOIN Q_ulaz ON Q_Izlaz.SSkl = Q_ulaz.SSkl;