SELECT tskladiste.Sifart, Last(IIf([sif_pj]="0001",[cjena],[m_cijena])) AS CijenaP, Sum(tskladiste.kolicina_ulaz) AS SumOfkolicina_ulaz, Sum(tskladiste.kolicina_izlaz) AS SumOfkolicina_izlaz, Sum([Kolicina_Ulaz]-[Kolicina_izlaz]) AS Stanje, tskladiste.sif_pj, Count(tskladiste.Sifart) AS CountOfSifart
FROM tskladiste
GROUP BY tskladiste.Sifart, tskladiste.sif_pj
ORDER BY tskladiste.sif_pj;