transpose

[kurt]

I have a tabel like this

master, detail
A,2
A,3
A,4
A,1
A,1
B,4
B,5
B,1

I would like to present theese data as

MAster, detail1, detail2, detail3 , detail4, detail5
A,2,3,4, 1,1
B,4,5
in a datasheet layout

Anyone have an Idea

Thanks

Kurt

 

[Jerry Whittle]

Something like below gets close except that it only shows one A1 combination:

TRANSFORM First(Kurt.detail) AS FirstOfdetail
SELECT Kurt.master AS Master
FROM Kurt
GROUP BY Kurt.master
PIVOT "detail" & [detail];