Group values

[Aqif]

Hi,

I got a table which looks like this

ProjID Surname
------------------------------------------
1 Name 1
1 Name 2
2 Name 1
3 Name 3
------------------------------------------
I want an output like


1 Name 1, Name 2
2 Name 1, Name 3

Any easy way to do this ? Thanks in advance




Cheers!
ÙÇãá

It's important to learn the rules so that you know how to break them.

 

[dhookom]

There is a generic concatenate function and sample usage at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]