Cross Tab Query question

[Guest]

Hello,

I have a table called tblContracts where ContractNumber is the unique
identifier.

I then have a table called tblAmendments where there can be multiple
AmendmentDates for a single Contract and also has ContractNumber where they
can be linked.

I also have a 3rd table called tblAttorneys where there can be multiple
Attorneys for a single Contract and also has ContractNumber where they can be
linked.

What I would like to return is for each Contract to then have seperate
columns for each of the Other Parties and then for each of the Ammendments.
See example:
I will be abbreviating the column names so I can fit it accross the screen.

Contract # Amdmnt 1 Amdmnt 2 Othr Pty 1 Othr Pty 2
-----------------------------------------------------------
A 01/01/05 01/15/05 Jeff Nancy
B 05/06/05 05/25/05 Tom Steve


I was able to figure out using a Cross Tab Query for each Contract to
display Other Parties as seperate columns or Ammendments as seperate columns
but not able to figure out how to do both.

Can what I ask be done, and if so, how ? What would be the SQL ?

Any help would be greatly appreciated.

Thank you,
Jeff

 

[Guest]

Would this work for you?
Contract # Amdmnt Othr Pty 1 Othr Pty 2

 

[Guest]

Hello,

No sorry I need the Amendments id different columns.

Jeff