JithuAccess
Member
- Local time
- Today, 08:24
- Joined
- Mar 3, 2020
- Messages
- 297
Hello Guys,
I was trying to Group Payment Amount with Payment Date.
This is my Query:
and This is my Query Result:
As you could see, for July, the Total Payment was $221,260.00 and $22,126.00 and this is showing Separately in the Query. I think if there are different Dates, Query is grouping the Paid Amount by Dates. I want to show this Monthly. Like For July 2020 the Total Paid Amount $243,386.00.
Could you please let me know how to do this?
Thanks
I was trying to Group Payment Amount with Payment Date.
This is my Query:
and This is my Query Result:
As you could see, for July, the Total Payment was $221,260.00 and $22,126.00 and this is showing Separately in the Query. I think if there are different Dates, Query is grouping the Paid Amount by Dates. I want to show this Monthly. Like For July 2020 the Total Paid Amount $243,386.00.
Could you please let me know how to do this?
Thanks