return report by date

[zxmax]

Greeting, i have a main form, with a subform. The sub form , i have 4 tables, IDdeposit , DepositDate , and DepositAmount and WithdrawAmount

i have an option to be able to print by date, so the user could select a date range

everything works fine in my report, but i realized that when we print by date, it only calculate the entry of these dates. What i would like to do is to display the records that is selected by the date range, but to include all of the previous entry in the calculation

My forumla is inside the Report itself, which is something like this, Total = (Totaldeposit-Totalwithdraw)

i hope i was clear explaining , if not let me knwo i'll explain it better,

Thanks for any inputs ,or help

 

[nabiS2K]

You should use the DSUM function.

Review this hyperlink for help on how to use the function:

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A0DF.asp

Let me know if you have any more questions or run into trouble.

 

[zxmax]

i have this line :

=DSum("[Sales_amt]","tblSales", "[Resident_id] = '1234'")

what i want to do is, instead of specifing the "residents_id, i want it to be selected from my sql statement ,

Could that be done ?

i have this in my sql statement under critiria for the Resident_id : [forms]![Residents]![Resident_ID]

so that means, my Resident_ID is selected from the main form, so i want the DSUM to sum only for the selected Resident,

i hope i was clear explaining

Thanks for anyadvise,