I want to print a report that shows a list of vendors to whom we have paid over $50,000 last year for a particular fund. I can get a query of vendors who have been paid, in total, over $50,000 (but to all of 5 funds), and a querie of invoices that POSTED to the fund in question, but I am having trouble combining the two. Stephen Gabrielli Agency Administrator L.A. Family Housing Corp. "Welcoming families home again"

If you pay each fund from one bank, you can filter for the bank information also.

The problem is that they are paid from the same bank. Our account structure is FF-CCCCCC-DDD, where F=Fund, C-Account Code, and D=Division. Some invoices may be split between two funds. So I need to know the sum of each fund portion of all the invoices paid to a vendor during the year. Stephen Gabrielli Agency Administrator L.A. Family Housing Corp. "Welcoming families home again"