Running sum by date

[Ray67]

Thank you
Should i make another query to gave me sum by month?

[Ray67]

Here is the query

Newdate	Year	Month	SumOfDepositAmount	SumOfWithdrawalAmount	YTD
9	2011	September	725.00	717.00	8
10	2011	October	2,330.00	525.65	1812.35

How can i call prior month total in reports with this query??

[June7]

Do you want report to show detail records? Here is revision of your report to consider. Open report and enter 11/1/2011 in the popup prompt.

[Ray67]

I don't want to show detail. Just sum for prior month. The query is based on transactiondate. I would need it to be based on Datecleared. I would just have to change the fiedls names to Datecleared.

[June7]

Well, you provided a report in your db that shows details so that's what I worked with.

If you don't want details then make the Detail section not visible or make report RecordSouce an aggregate query, probably the one you show in post17.

Calculate the starting balance in textbox as I show in demo, adjust as appropriate for date criteria.

Does this now resolve this issue?

[Ray67]

Yes Thank you very much

[Ray67]

June7

I was looking at your post 15. How can i make the static of the date criteria reference to a form???

[June7]

Concatenate variables. Reference to control on form is a variable.

=DSum("[DepositAmount]-[WithdrawalAmount]","T_Transactions","[TransactionDate]<#" & Me.textbox & "#")

[Ray67]

=DSum("[DepositAmount]-[WithdrawalAmount]","T_Transactions","[DateCleared]<#" & Me.servicefrom & "#")

Not sure i did this right. After i enter the date on the form i get Enter Parameter Value ME

[June7]

Sorry, I used syntax for VBA.

=DSum("[DepositAmount]-[WithdrawalAmount]","T_Transactions","[TransactionDate]<#" & Forms!formname!servicefrom & "#")

[Ray67]

Thank you that wroked