Help sa Access SQL mga master!

[jocno1212]

Mga master, patulong naman, paano ko ba ieexecute yung query para dito para makuha ko yung overdue

Example:
Si client 3 may overdue from the month of January and February, Php300.00 each month.

Paano ko ba gagawan ng query yun na magiging ganito itsura assuming na as of March yung summary na gusto ko i-generate?

Pahelp naman po, mabubuwang na ako kakaisip po eh, BTW, access po ang gamit ko sa paggawa ng query ha, ADVANCE THANK YOU SA TUTULONG!





View attachment 261602
View attachment 261601

 

[rypercap2]

Can you please try this:

SELECT client_no,bill_date,due_date,bill_amount,OVERDUE,remarks FROM(
SELECT a.*,
CASE when client_no = '1' then ""
when client_no = '2' then ""
when client_no = '3' then a.O else "" end as 'OVERDUE' FROM
(SELECT client_no,bill_date,due_date,bill_amount,remarks,(SELECT SUM(bill_amount) FROM sample_table WHERE bill_date='2016-03-01' and remarks<>'Unpaid') O
FROM sample_table WHERE bill_date='2016-03-01' GROUP BY client_no )a )a

I created my own table.

Hope this will help you.

Please see below result screenshot.

 

[xloverboyx]

TS,, i select mo nalang ang unpaid sa table mo as of march then i sum mo nalng kng makano ang bill amount.

SELECT *,SUM(Bill_Amoun)AS Balance Due FROM tbl_BILLS WHERE DueDate <= #03-31-2016# AND Remarks = 'UNPAID'