AccessTr.neT

rakam ve harf karışımı. Yani bir programın lisans kodları gibi düşünün.
546545EŞDOKDOIUM54146DŞMDĞOID GİBİ

aşağıdaki sorguyu dener misiniz?

SELECT A.[#msg_S_0200], A.[#msg_S_0201], A.msg_S_0089, A.msg_S_0090, A.msg_S_0091, A.msg_S_0094, A.msg_S_0003, A.[#msg_S_0085], (select sum(dbo_SQLKASA1.[msg_S_0101\T]-dbo_SQLKASA1.[msg_S_0102\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088]) AS Bakiye

FROM dbo_SQLKASA1 AS A

WHERE (((A.[#msg_S_0200])="100.01"))

ORDER BY A.[#msg_S_0085];

Sorgu çalıştı ama .[msg_S_0101\T] VE .[msg_S_0102\T] alanlar sorguyu çalıştır dediğimde gözükmedi doüru olup olmadığını anlayamadım
Saygılar

---

pardon hata bendeymiş ama sorgu doğru çalışmadı sadece bakiye olan satırı en sona atıyor toplama yada çıkarma yapmıyor. Eğer hatalı birşey yapmadıysam

SELECT A.[#msg_S_0200], A.[#msg_S_0201], A.msg_S_0089, A.msg_S_0090, A.msg_S_0091, A.msg_S_0094, A.msg_S_0003, A.[#msg_S_0085], ((select sum(dbo_SQLKASA1.[msg_S_0101\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088])-(select sum(dbo_SQLKASA1.[msg_S_0102\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088])) AS Bakiye, A.[msg_S_0101\T], A.[msg_S_0102\T]

FROM dbo_SQLKASA1 AS A

WHERE (((A.[#msg_S_0200])="100.01"))

ORDER BY A.[#msg_S_0085], A.[#msg_S_0088];

---

yada

SELECT A.[#msg_S_0200], A.[#msg_S_0201], A.msg_S_0089, A.msg_S_0090, A.msg_S_0091, A.msg_S_0094, A.msg_S_0003, A.[#msg_S_0085], (select sum(dbo_SQLKASA1.[msg_S_0101\T])-sum(dbo_SQLKASA1.[msg_S_0102\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088]) AS Bakiye, A.[msg_S_0101\T], A.[msg_S_0102\T]

FROM dbo_SQLKASA1 AS A

WHERE (((A.[#msg_S_0200])="100.01"))

ORDER BY A.[#msg_S_0085], A.[#msg_S_0088];

(23/12/2021, 17:58)berduş yazdı: [ -> ]

SELECT A.[#msg_S_0200], A.[#msg_S_0201], A.msg_S_0089, A.msg_S_0090, A.msg_S_0091, A.msg_S_0094, A.msg_S_0003, A.[#msg_S_0085], ((select sum(dbo_SQLKASA1.[msg_S_0101\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088])-(select sum(dbo_SQLKASA1.[msg_S_0102\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088])) AS Bakiye, A.[msg_S_0101\T], A.[msg_S_0102\T]

FROM dbo_SQLKASA1 AS A

WHERE (((A.[#msg_S_0200])="100.01"))

ORDER BY A.[#msg_S_0085], A.[#msg_S_0088];

---

yada

SELECT A.[#msg_S_0200], A.[#msg_S_0201], A.msg_S_0089, A.msg_S_0090, A.msg_S_0091, A.msg_S_0094, A.msg_S_0003, A.[#msg_S_0085], (select sum(dbo_SQLKASA1.[msg_S_0101\T])-sum(dbo_SQLKASA1.[msg_S_0102\T]) from dbo_SQLKASA1 where  dbo_SQLKASA1.[#msg_S_0085]=A.[#msg_S_0085] and  dbo_SQLKASA1.[#msg_S_0088]<=A.[#msg_S_0088]) AS Bakiye, A.[msg_S_0101\T], A.[msg_S_0102\T]

FROM dbo_SQLKASA1 AS A

WHERE (((A.[#msg_S_0200])="100.01"))

ORDER BY A.[#msg_S_0085], A.[#msg_S_0088];

Maalesef ekteki şekilde çıkıyor doğru bakiye vermiyor

Çalışmanızı isme gore sıralayıp resmini atar mısınız?
Bende düzenli gidiyordu.