Totalling fields from other tables and performing a calculation

K

KLP

I have 2 tables - Loan info and Collateral. In a report, I need to compute
and display the total loan amount, total collateral value, and compute a
loan-to-value ratio for each loan. One loan can have multiple pieces of
collateral. So I got the totals and the LTV using queries. In the report,
Collateral is a sub-report of Loan Info, and I inserted the LTV report as a
sub-repot of Collateral. The totals and LTV display correctly, however,
they are shown for each loan. In the LTV report it shows each loan and the
totals for balance, value and LTV. How do I get it to show only once?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top