Member Avatar for Fawad0301

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,

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by timothybard
Member Avatar for timothybard

Just so I'm clear... when you view the report on your computer, everything looks okay, but when you print the report from your printer, the values are incorrect?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.