Statement of account

[ZahleServ]

Hi All, I would appreciate your help with this small issue:


How can I create a report listing records from 2 tables:
tblInvoices & tblReceipts

I would like to show what is paid and what is due in the same report. I tried to create a single query including both tables but if I have 2 invoices and 1 Receipt the report repeat the value of the Receipt.

Any idea how to deal with it. Thanks in advance

 

[Hayley Baxter]

In the properties of the receipt set hide duplicates to yes.

 

[ZahleServ]

10x but It works only if you have multiple invoices and 1 receipt, I added 3 receipts and 4 invoices, It's a mess. I have the same 3 receipts with every invoice. Any other method?

 

[Rich]

Use a subReport to display receipts

 

[ZahleServ]

I can't use a subreport when using continuous data

 

[Rich]

Then use a Union query and a calculated control to show the balance, if you have multiple receipts per invoice then you'll have to use Totals queries