I am designing a report Using the Data Reports in VB 6.0.
I have 2 fields called Fees and Deposit respectively.
What i want to do is add the fields Fees at the end of the
report (using the Function control via Sum) and do the
same with also deposit.
Then I want to add the Fees total and the Deposit total
to get what I have called Final total.
Here's an example,
Counter Fees Deposit
1 1000 2000
2 1000 2000
3 1000 2000
Fees total 3000 6000 Deposit total
Final total: 3000+ 6000 = 9000
The problem I encounter is that you can't insert a Function
control in the Page Footer of the Data Report Designer.
You can insert it inside the Report Footer but than how do
I add the Fees total and Deposit total.
Any help please,