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?

 

[Marshall Barton]

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?

I think there is a way to do that with SQL, but it's too
complicated for me to follow. The standard way is to use a
function such as the one available at:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16&SID=b71z2d8dae9eaz17f23c5876e252c77c