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?