Report Design with Two Child Tables

[Robert T]

I created a little billing database for our home improvement loan. There is a
One to Many Relationship between tblVendors and TblExpenses linked by the
VendorID field. There is also a One to Many Relationship between tblVendors
and tblPayments, also linked by VendorID.

I can create a report, grouped by Vendor, listing all of the expenses for
each Vendor.
I can create a report, grouped by Vendor, listing all of the payments to
each Vendor.

However, I'm having a mental block trying to combine the above into one
report which lists the expenses charged by each vendor, all of the payments
made to each vendor, and the Current Balance Due.

Any suggestions would be greately appreciated.

Thanks,
Robert

 

[Duane Hookom]

My first attempt would be to create a union query of the expenses and
payments. Then join this to the vendors to create a report.

If you can't do that, use one or two subreports.