|
Dear Sir,
I have developed the database program for storing the Company bills. it has two table COMPANY & COMPANYBILL. It has 1-Many relationship. In the COMPANYBILL table i am storing the BillAmount and PaidAmount. Also i have create a form for the COMPANYBILL. The Report shows the BillAmount, PaidAmount and Balance. The Balance Value I have written a code in Detail_On_Print Section Like:
Balance is unbound textbox and have 0 value.
Balance = Balance + NZ([BillAmount],0)-NZ([PaidAmount]), which is working perfectly. but sir the big problem is that when i want to print the last page of my all report it create wrong values in Balance Fields in Report.
Please guide me about that problem or please tell me the alternate way.
Regards,
| 
