Data into columns

[Ty Gooden]

Hi,

I was wondering if anyone knew a way of creating a query that arranges the data in the table below

Ref ID
63 ID6
63 ID5
63 ID7
63 ID11
64 ID2
64 ID3
66 ID4
66 ID10
69 ID9
72 ID1
73 ID8

into the format in a query

Ref 1 2 3 4
63 ID6 ID5 ID7 ID11
64 ID2 ID3
66 ID4 ID10
69 ID9
72 ID1
73 ID8

I was thinking of ranking the IDs in a query and then creating another query with those rankings as column headers but I can't find a ramking function.

Any ideas would be appreciated.

 

[namliam]

Try a normal crosstab and see if that might work for you, Ranking dont exist in access.

You can make your own function to add a ranking to your query then crosstab the result of that query...