 |  |  |  |  |  |  |  |
Problem in ms access report
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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.
Me.Balance = [Balance] +2B 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,
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.
Me.Balance = [Balance] +2B 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,
Last edited by Fawad0301; Nov 21st, 2008 at 6:55 am.
|
Similar Threads
- Crystal Report Exception Error when Viewing (Visual Basic 4 / 5 / 6)
- How to execute MS Access Query using JDBC? (Java)
- Crystal Report Exception Error when Viewing (IT Professionals' Lounge)
- Crystal Report Design!!!!! (VB.NET)
- Ad/Spy/Malware problem that I can't fix (Viruses, Spyware and other Nasties)
- Access Linking a Form to a report (MS Access and FileMaker Pro)
- problem in exporting crystal report (ASP.NET)
- Hijacking of home Page/access to hotmail (Viruses, Spyware and other Nasties)
- HELP!!! very strange problem! (Troubleshooting Dead Machines)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: sort fields in queries
- Next Thread: Help with code modification
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
