- Katılım
- 5 Kasım 2007
- Mesajlar
- 18
- Excel Vers. ve Dili
- excel 2003
Access de sorgularda yaptırdığım hesaplamaların kümülatif toplamlarını bir başka sütunda nasıl yazdırabilirim?
DOSYA İndirmek/Yüklemek için ÜCRETLİ ALTIN ÜYELİK Gereklidir!
Altın Üyelik Hakkında Bilgi
SELECT Course, Credit, Semester, Grade, Credit*Grade AS Kazanılan,
Round((select sum(credit) from tablo1)/([credit]+[grade]),2) AS notort
FROM Tablo1 AS trz
SELECT Course, Credit, Semester, Grade, Credit*Grade AS Kazanılan,
Round((select sum(credit) from tablo1 where credit=trz.credit)/([credit]+[grade] ),2) AS notort
FROM Tablo1 AS trz
SELECT Course, Credit, Grade, [credit]*[grade] AS KrediNot,
(select sum( [credit]*[grade]) from Tablo1 where course=trz.course) AS KrediNotTop,
(select sum(credit) from tablo1 where credit=trz.credit) AS KrediTop,
[KrediNotTop]/[KrediTop] AS DersOrt
FROM Tablo1 AS trz
SELECT Course, Credit, Grade, [credit]*[grade] AS KrediNot,
(select sum( [credit]*[grade]) from Tablo1) AS KrediNotTop,
(select sum(credit) from tablo1) AS KrediTop,
Round( [KrediNotTop]/[KrediTop],4) AS DersOrt
FROM Tablo1 AS trz
SELECT Course, Credit, Grade, [credit]*[grade] AS KrediNot,
dsum("[credit]*[grade]","Tablo1") AS KrediNotTop,
dsum("credit","tablo1") AS KrediTop,
Round( [KrediNotTop]/[KrediTop],4) AS DersOrt
FROM Tablo1 AS trz;