Access query issue

August 8, 2011 at 08:32:11
Specs: Windows XP
Hi

I have this data in ACCESS table

id no tx
50251 2 a
50251 2 c
50251 2 d
50251 2 f
50251 3 b
50251 3 e
50251 4 g
50251 6 h

which I want to convert in this format

id no tx1 tx2 tx3 tx4
50251 2 a c d f
50251 3 b e
50251 4 g
50251 6 h

Please can you help?

many thanks
H


See More: Access query issue

Report •


#1
August 8, 2011 at 14:32:49
First is 4 the max number of subitems.

Report •
Related Solutions


Ask Question