SELECT tblBanka.BrojRa
una, Sum(nz([NetoIznos],0)) AS IznosUlaza, Nz(Sum([Kolicina]*[cena]),0) AS IZnosIzlaza, Sum(NZ([NetoIznos],0))-Sum(NZ([Kolicina]*[Cena],0)) AS Stanje
FROM ((tblBanka LEFT JOIN tblNovacIzlaz ON tblBanka.ID_Ra
unBanke = tblNovacIzlaz.ID_Ra
unBanke) LEFT JOIN tblNovacUlaz ON tblBanka.ID_Ra
unBanke = tblNovacUlaz.ID_Ra
unBanke) LEFT JOIN tblNovacIzlazRacun ON tblNovacIzlaz.ID_Ra
un = tblNovacIzlazRacun.ID_Ra
un
GROUP BY tblBanka.BrojRa
una;