By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,925 Members | 1,863 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,925 IT Pros & Developers. It's quick & easy.

Problem in ms access report

P: 1
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.

Nov 21 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.