Cross Tab Query - I Think

[ShawnR]

I have two tables. One is Calls and one is WhatWeDid. They are linked by a CallID with primary nad foriegn keys. The structure of the tables follows.

Calls Table
CallID etc...

WhatWeDid Table

ID CallID WhatWeDidID TimeIndex

The WhatWeDid Table has a one to many relationship to the Calls table. So the WhatWeDid table is as follows:


ID CallID WhatWeDid
1 2244 12
2 2244 16
3 2450 8
4 2450 12
5 2460 1
6 2500 12
7 2500 1
8 2500 44


What I want to be able to do is run a query where i can match up the multiple WhatWeDid numbers in a row instead of a column and then link them to the CallID. So when I run it the query or table would look like this.

CallID WhatWeDID1 WhatWeDid2 WhatWeDid3 WhatWeDid#
2244 12 16
2450 8 12
2460 1
2500 12 1 44


I have 138 WhatWeDid ID's and growing. In a CrossTab Query is lists every WhatWeDid instead of the ones that were in the record like I want it above. And for this instance I don't need to count anything.

Thanks. If this doesn't make sense let me know. I can go into more detail if needed.