SELECT T_Veriler.[STOK], T_Veriler.[PLANLANAN], T_Veriler.[SİPARİŞİ]

, T_Veriler.TERMİN1, IIf([SİPARİŞİ]>=[TERMİN1],[TERMİN1],[SİPARİŞİ]) AS Gelen1, IIf([SİPARİŞİ]>=[Gelen1],[SİPARİŞİ]-[Gelen1],0) AS KALANSP1

, T_Veriler.TERMİN2, IIf([KALANSP1]>=[TERMİN2],[TERMİN2],[KALANSP1]) AS GELEN2, IIf([KALANSP1]>=[Gelen2],[KALANSP1]-[Gelen2],0) AS KALANSP2

, T_Veriler.TERMİN3, IIf([KALANSP2]>=[TERMİN3],[TERMİN3],[KALANSP2]) AS GELEN3, IIf([KALANSP2]>=[Gelen3],[KALANSP2]-[Gelen3],0) AS KALANSP3

, T_Veriler.TERMİN4, IIf([KALANSP3]>=[TERMİN4],[TERMİN4],[KALANSP3]) AS GELEN4, IIf([KALANSP3]>=[Gelen4],[KALANSP3]-[Gelen4],0) AS KALANSP4

, T_Veriler.TERMİN5, IIf([KALANSP4]>=[TERMİN5],[TERMİN5],[KALANSP4]) AS GELEN5, IIf([KALANSP4]>=[Gelen5],[KALANSP4]-[Gelen5],0) AS KALANSP5

FROM T_Veriler

ORDER BY T_Veriler.STOK;