SELECT SIRALAMA.LISTE_URETIM_SIRA, SIRALAMA.LISTE_KIMLIK, (select count([gsno]) from Sorgu4  where  [gsno]<=SIRALAMA.[gsno]) AS sira

FROM (SELECT dbo_SIPARIS_LISTE.LISTE_URETIM_SIRA, dbo_SIPARIS_LISTE.LISTE_KIMLIK, Val([LISTE_URETIM_SIRA] & [LISTE_KIMLIK]) AS gsno

FROM dbo_SIPARIS_LISTE

WHERE (((dbo_SIPARIS_LISTE.LISTE_URETIM_SIRA)<1000))

ORDER BY dbo_SIPARIS_LISTE.LISTE_URETIM_SIRA, dbo_SIPARIS_LISTE.LISTE_KIMLIK) AS SIRALAMA;

SELECT dbo_SIPARIS_LISTE.LISTE_URETIM_SIRA, dbo_SIPARIS_LISTE.LISTE_KIMLIK, Val([LISTE_URETIM_SIRA] & [LISTE_KIMLIK]) AS gsno

FROM dbo_SIPARIS_LISTE

WHERE (((dbo_SIPARIS_LISTE.LISTE_URETIM_SIRA)<1000))

ORDER BY dbo_SIPARIS_LISTE.LISTE_URETIM_SIRA, dbo_SIPARIS_LISTE.LISTE_KIMLIK;

SELECT SIRALAMA.LISTE_URETIM_SIRA, SIRALAMA.LISTE_KIMLIK, (select count([gsno]) from Sorgu4  where  [gsno]<=SIRALAMA.[gsno]) AS sira

FROM Sorgu4 AS SIRALAMA;