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?
 
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...

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