Sabtu, 01 Juni 2013

[MS_AccessPros] Concatenating names in a group.

 

I have a dataset that includes 'ClubName' and 'Group'.

GroupID ClubName
1 Club 1
2 Club 7
1 Club 11
2 Club 17
1 Club 21
2 Club 37

and so on.

Clubs are arranged in groups and I need a query that gives me a
result like this in two fields:

Group One - Club 1; Club 2; Club 3; etc
Group Two - Club 22; Club 27; Club 40; etc

Many thanks,

Robin Chapple

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar