Report "90-BestReport-By-loan no-7-18-08-NEW-2" of the attached database is grouped by the due date one due date by month, another due date by each due date value). Report counted lines for each individual loan and calculates number of loans. As you can see that each loan has multiple lines to provide insurance information.
Problem: I'm not able to correctly calculate number of loans for the month and for the year. Current reprot calculates number of lines for the month. I need number of Loans as well.
When you open this report it will ask you for the fields, please simply click on those fields (they are not for display purposes)
Report: "qryDistinct-Loan-No-due-d
ate subreport1" shows number of loans based on due date value--this report I was able to integrate.
Report: "qryDistinct-Loan-No-due-d
ate-monthl
y subreport" shows number of loans based on due date on monthly basys. When I'm trying to integrate this report I got incorrect number of loans
Please send answer using winzip, don't use winrar
Start Free Trial
