Linking/Matching multiple IDs

[Julieve]

Having some trouble with reporting showing the two parties on the loan.. I have built a query combining the transaction Data with the PartyTypes and Loan information and included a calculated field in it, so that lender amount is positive and the borrower entry is negative.. In order to show the other party in any reports, how would I include a field for the other party in the query? Like a lookup but in the query.. this is a bit beyond me..

[Julieve]

Yay.. Ive worked it out.. I used the wizard to do a cross tab query in a new query to get the lender and borrower into one line which could then be used by the report..

[jzwp11]

You're welcome. Good luck with your project.