Selamat pagi para master access, saya lagi coba-coba membuat laporan stok inventory, dengan query2 sbb:
1. Q untuk history transaksi :
SELECT NoATK, Tanggal,JumlahPenerimaan as inQty, 0 as outQty from QIn
UNION ALL select NoATK, Tanggal, 0 as InQty, JumlahPemakaian as outQty
FROM Qout
ORDER BY Tanggal;
UNION ALL select NoATK, Tanggal, 0 as InQty, JumlahPemakaian as outQty
FROM Qout
ORDER BY Tanggal;
2. Q report bulanan :
SELECT NoATK, Tanggal,sum(inQ) as inQty, sum(outQ) as outQty from Qhistory
WHERE Tanggal < [start date]
UNION ALL select NoATK, Tgl as Tanggal, inQ as inQty, outQ as outQty
FROM Qhistory
WHERE tgl between [start date] and [end date]
ORDER BY NoATK;
WHERE Tanggal < [start date]
UNION ALL select NoATK, Tgl as Tanggal, inQ as inQty, outQ as outQty
FROM Qhistory
WHERE tgl between [start date] and [end date]
ORDER BY NoATK;
Sewaktu run di Q yg kedua ada peringatan
You tried to execute a query that does not include the specified expression 'NoATK' as part of an aggregate function. (Error 3122)Kira2 apa yang salah ya? Ada yang bisa bantu?
Terima kasih.
__._,_.___
SPAM IS PROHIBITED
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar