transpose

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kurt - 16 Jan 2008 11:54 GMT

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

Reply to this Message

Jerry Whittle - 16 Jan 2008 15:43 GMT

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];

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have a tabel like this
>
[quoted text clipped - 20 lines]
>
> Kurt

Reply to this Message