SELECT trz.iplik_ne, 
Nz(Round((SELECT MAX(Devir) FROM Srgdevir WHERE trz.iplik_ne=Srgdevir.iplik_ne),2),0) AS Devir, 
Format(Nz((SELECT SUM(iplik_kg) FROM Tbluretim WHERE trz.iplik_no=Tbluretim.iplik_ne 
AND  Tarih=[Forms]![FrmAna]![Tarih] ),0),"Standard") AS [iplik Kg], 
Format(Nz((SELECT SUM(iplik_paketlenen) 
FROM Tblpaketlenen WHERE trz.iplik_no=Tblpaketlenen.iplik_ne 
AND 
                                    Tarih=[Forms]![FrmAna]![Tarih] ),0),"Standard") AS [iplik Paketlenen], 
Val([Devir])+Val([iplik Paketlenen]) AS Toplam, 
Format(Nz((SELECT SUM(Kg) FROM Tblsatislar WHERE trz.iplik_no=Tblsatislar.iplik 
AND 
                                    Tarih=[Forms]![FrmAna]![Tarih] ),0),"Standard") AS Cikislar, 
[Toplam]-[Cikislar] AS Kalan, trz.iplik_lot, trz.iplik_sıra
FROM Tbliplik AS trz
WHERE (((trz.Gorunur)=TRUE))
ORDER BY trz.iplik_sıra;