Best Way To Do It? - A Query For Statements

[CharlesWhiteman]

Hi All,

In my Db I have TblInvoices & TblFinanceReceipts

I want a query which brings all the transactions from each (the relationship will be based on companycode) to show in a report which I can thenuse to build a customer statement.

Whats the best way to do this please?

 

[CharlesWhiteman]

Hi Pat, Thanks for that answer which I've been able to do something with

SELECT CompanyCode, [InvDate], [Order Value]
FROM QryFSI
UNION ALL
SELECT CompanyCode, [RecDate], [Amount Received]
FROM QryFSR;

This works quite nicely but I think i need to redesign my Db to have, as you say, all the transactions in one Tbl - but that will take a bit of work to implement but definately looks like the correct way to take it.