Current month and year report

[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

 

[KARL DEWEY]

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;

 

[Nur Muhammad]

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 ...

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

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