rudolfelizabeth
Programmer
The statement below must provide the value for the beginbalance(the Previous Balance for the report.)
the user asked for when he enters the startdate,
the value must be all the records of the account for the user input, <= the startdate.(it doesnot produce any result with the criteria part, when I take out the criteria part it produces the sum over all the transactions )
Then I will ran another query to produce the current transactions
that means between startdate and stopdate.
lay out of report
value of Dsum beginbalance 2000.00
transactions charges 100.00 2100.00
and payment 1100.00 1000.00
Charge 50.00 1050.00
and so on
In the Header you get
Previuos balance (beginbalance 2000.00)
Total charges 150.00
Total of payments 1100.00
Closing balance 1050.00
the user asked for when he enters the startdate,
the value must be all the records of the account for the user input, <= the startdate.(it doesnot produce any result with the criteria part, when I take out the criteria part it produces the sum over all the transactions )
Then I will ran another query to produce the current transactions
that means between startdate and stopdate.
lay out of report
value of Dsum beginbalance 2000.00
transactions charges 100.00 2100.00
and payment 1100.00 1000.00
Charge 50.00 1050.00
and so on
In the Header you get
Previuos balance (beginbalance 2000.00)
Total charges 150.00
Total of payments 1100.00
Closing balance 1050.00