Expand rows into columns

[smithredmist]

Hi,

Fairly new to access queries and am trying to achieve the following..

Current Data
============

ID, Name
---------
1, John Smith
1, Jane Smith
2, Michael Jones
2, Kevin Simpson

Desired Query Ouput
===================

ID, Name1, Name2
-----------------
1, John Smith, Jane Smith
2, Michael Jones, Kevin Simpson

Probably all I need is a hint as to what it is I'm trying to do.

Thanks

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[smithredmist]

Brilliant. Exactly what I was after. Massive thanks, Duane.

Have a nice day.