Good morning all,
Novice user here, trying to join 3 tables, namely tblContracts, tblProjects and tblInvoices....
Idea is to have a query to run a report - see Financial Report by Area, where it shows projects, associated contracts and associated invoices received , managed to join projects and contracts - see test query and where I got confused
Basically for each line in the report, it should show the total invoiced amount, if there any invoice attached?
On a separate question, you'll notice there are 3 different types of contracts in the tblContract, is there any way to total them up in a way, so in the report I can chow them as separate totals (columns) on the top instead of listing them down?
Would appreciate your help........ and thanks in advance,
Erol
Novice user here, trying to join 3 tables, namely tblContracts, tblProjects and tblInvoices....
Idea is to have a query to run a report - see Financial Report by Area, where it shows projects, associated contracts and associated invoices received , managed to join projects and contracts - see test query and where I got confused
Basically for each line in the report, it should show the total invoiced amount, if there any invoice attached?
On a separate question, you'll notice there are 3 different types of contracts in the tblContract, is there any way to total them up in a way, so in the report I can chow them as separate totals (columns) on the top instead of listing them down?
Would appreciate your help........ and thanks in advance,
Erol