Combine results together with query

[mchadwick]

I have some data I want to combine together in one field. So I have two users we'll call them Bob and Sally. Bob has 3 computers; comp1, comp2 and comp3. Sally has 2 computers comp4 and comp5. they are listing in the table/query with one record for each computer


Name Computers
Bob comp1
Bob comp2
Bob comp3
sally comp4
sally comp5

I want to end up with this
Name Computers
Bob comp1; comp2; comp3
Sally comp4; comp5

How can I do that?

[CJ_London]

there are two methods - one is is called 'concatrelated'. There are various examples around, all working off the same principle. Here is a link to one of them
http://allenbrowne.com/func-concat.html

The other is a crosstab query but given there are only two columns and looks like you want to end up with two columns, probably not appropriate in this case.

[Welshgasman]

theDBguy has a function as well.

http://www.accessmvp.com/thedbguy/co...itle=simplecsv