Joining 3 tables....

[TajikBoy]

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

 

[isladogs]

Hi Erol
Welcome to AWF.
You forgot to attach your file

 

[Dreamweaver]

Hi Erol welcome aboard!

 

[TajikBoy]

Opps

 

[jdraw]

Some general comments on your tables.
-use names without embedded spaces for fields
-use names with no special characters ( %) use alpha/numeric and underscore(_) only
-be cautious of attachment fields ( known to increase bloat in some circumstances)
I have not reviewed any logic/processing etc.

There are several data models at Barry Williams' site.
Here's one Customers Invoices that may be helpful.
Good luck.