2

I have seen that strings can be concatenated in Access with &.

However, I cannot write the following query:

SELECT age, &names ==> this line does not work, how can I concatenate the strings? 
    FROM table GROUP BY age;

So that I get for example: "30; JohnWilliamPeter", all of them 30 years old.

Any way to do that?

Code Lღver
  • 15,573
  • 16
  • 56
  • 75
meddi
  • 21
  • 1
  • 1
  • 2

1 Answers1

1

Do you mean:

 SELECT age & "; " & names
 FROM table 
 GROUP BY age & "; " & names

However, this seems like you are aiming at a solution that should be presentation, not SQL.

Fionnuala
  • 90,370
  • 7
  • 114
  • 152
  • I don't want to concatenate the age and the name, but a list of names. I just found on another thread that there is no way to do that without using a MS function: http://stackoverflow.com/questions/5174362/microsoft-access-condense-multiple-lines-in-a-table/5174843#5174843 That's bad! – meddi Apr 11 '12 at 12:30