You can use the generic concatenate function at http://www.tek-tips.com/faqs.cfm?fid=4233.
Duane Hookom MVP
MS Access
> From: robinski@mymail.net.au
>
> 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
[Non-text portions of this message have been removed]
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar