Horizontal Listing

[Stu]

Table Data:
ID NAME
1 tom
1 dick
2 harry
3 joe
3 me
3 yourname here
Each ID has 1 to 4 names.
I would like the names to come out horizontally on my report but not in
fixed columns:
1 tom dick
2 harry
3 joe me yourname here

Please advise....is VBA the only solution?

 

[John W. Vinson]

Table Data:
ID NAME
1 tom
1 dick
2 harry
3 joe
3 me
3 yourname here
Each ID has 1 to 4 names.
I would like the names to come out horizontally on my report but not in
fixed columns:
1 tom dick
2 harry
3 joe me yourname here

Please advise....is VBA the only solution?

That, or a really snarky multiple self join query. There's VBA code available
that you can easily adapt:

http://www.mvps.org/access/modules/mdl0004.htm

 

[Stu]

This question should be in the Access reports group. Will re-post there.

 

[De Jager]

Table Data:
ID NAME
1 tom
1 dick
2 harry
3 joe
3 me
3 yourname here
Each ID has 1 to 4 names.
I would like the names to come out horizontally on my report but not in
fixed columns:
1 tom dick
2 harry
3 joe me yourname here

Please advise....is VBA the only solution?