Current month and year report

  • Thread starter Thread starter Nur Muhammad
  • Start date Start date
N

Nur Muhammad

I want to see the sum of current month, current year approved loan amount
like that:
Period Sum of Approved
Current month (April 1st to Till Now 7000000
Current Year ( Jan 01 To Till Now 10000000

Pls reply me as early as possible
 
Try this using your table and field names ---
SELECT Sum(IIf(Format([Posted],"yyyy")=Format(Date(),"yyyy"),[Transaction
Amount],0)) AS [Current Year], Sum(IIf([Posted] Between Date()-Day(Date())+1
And Date(),[Transaction Amount],0)) AS [Current Month]
FROM Accounting;
 
Dear Friend:
I want to use Domain Function
I have succeed to prepar yearly Approved Limit but can not monthly
Yealy Approved Limit as follow:
=DSum("[car_sanction_limit] ","tbl_car_master","month([car_disburse_date] )")

Pls response me as early as ...

KARL DEWEY said:
Try this using your table and field names ---
SELECT Sum(IIf(Format([Posted],"yyyy")=Format(Date(),"yyyy"),[Transaction
Amount],0)) AS [Current Year], Sum(IIf([Posted] Between Date()-Day(Date())+1
And Date(),[Transaction Amount],0)) AS [Current Month]
FROM Accounting;

--
KARL DEWEY
Build a little - Test a little


Nur Muhammad said:
I want to see the sum of current month, current year approved loan amount
like that:
Period Sum of Approved
Current month (April 1st to Till Now 7000000
Current Year ( Jan 01 To Till Now 10000000

Pls reply me as early as possible
Click to expand...
Click to expand...
 
Back
Top