Multiple Table Query

  • Thread starter dazoloko via AccessMonster.com
  • Start date
D

dazoloko via AccessMonster.com

Dear All,

I hope someone can help me

I have three tables

Contract Details
Invoices
Variations

There can be more than one invoice or more than one variation for each
contract, the tables are linked via a 'Contract Ref' field which is the
Primary Key in the 'Contract Details' Table. My aim is to be able to create a
report which will show the Contract Details at the top and a summary of all
invoices and all variations underneath that go with that contract. I am OK on
designing reports. Its the initial query I am having the trouble with. Ive
had go at it but get an 'Ambiguous Outer Join................' Message. Can
Anyone tell me where I could be going wrong ?

Cheers

D
 
M

Michel Walsh

Make a query with two of the tables (with the required joins and select the
required fields). Save it. Make a second query, bring the just saved query
and the third table; make the joins, and select the required fields. Save
it, and use it for your report.

That procedure is required only in some cases where two outer joins are
involved in such a way that their order of execution CAN change the final
result. So, just in case, be sure the first query you saved is, "logically",
the first step to be performed. The second query will see the result of this
first query, not the original tables anymore.



Hoping it may help,
Vanderghast, Access MVP
 
D

dazoloko via AccessMonster.com

Thanks Michel, just the job !

D


Michel said:
Make a query with two of the tables (with the required joins and select the
required fields). Save it. Make a second query, bring the just saved query
and the third table; make the joins, and select the required fields. Save
it, and use it for your report.

That procedure is required only in some cases where two outer joins are
involved in such a way that their order of execution CAN change the final
result. So, just in case, be sure the first query you saved is, "logically",
the first step to be performed. The second query will see the result of this
first query, not the original tables anymore.

Hoping it may help,
Vanderghast, Access MVP
Dear All,
Click to expand...
[quoted text clipped - 22 lines]
D
Click to expand...
Click to expand...
 
Top