Horizontal Listing

  • Thread starter Thread starter Stu
  • Start date Start date
S

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?
 
Stu said:
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?
Click to expand...


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
 
Back
Top