+- AccessTr.neT (https://accesstr.net)
+-- Forum: Microsoft Access (https://accesstr.net/forum-microsoft-access.html)
+--- Forum: Access Cevaplanmış Soruları (https://accesstr.net/forum-access-cevaplanmis-sorulari.html)
+--- Konu Başlığı: Access Sorguda Yürüyen Bakiye (/konu-access-sorguda-yuruyen-bakiye.html)
RE: Access Sorguda Yürüyen Bakiye - dogan.importexport - 23/12/2021
rakam ve harf karışımı. Yani bir programın lisans kodları gibi düşünün.
546545EŞDOKDOIUM54146DŞMDĞOID GİBİ
RE: Access Sorguda Yürüyen Bakiye - berduş - 23/12/2021
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];RE: Access Sorguda Yürüyen Bakiye - dogan.importexport - 23/12/2021
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
RE: Access Sorguda Yürüyen Bakiye - berduş - 23/12/2021
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];RE: Access Sorguda Yürüyen Bakiye - dogan.importexport - 23/12/2021
(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
RE: Access Sorguda Yürüyen Bakiye - berduş - 23/12/2021
Çalışmanızı isme gore sıralayıp resmini atar mısınız?
Bende düzenli gidiyordu.