query design help needed

[Gary F Shelton]

Not even sure how to type this but I will give it a go
I have the following data.
Sku Plant WHS Contact Person
12345 11 AA Gary
12345 11 AA Tim
12345 11 AA Joe

What I want is to take the last column "Contact Person" and transpose the
data and then I want to concatonate the "Contact Person" into the same field
(seperate by a comma if need be...)

End result will look like:
Sku Plant WHS Contact Person
12345 11 AA Gary, Tim, Joe

The question you might have is how many combinations of names might I
have... Let's say at max is ten...

Thanks in advance for any help.

 

[Lord Kelvan]

yea you really need to do that from a report not a query you can run a
loop in the form to concatanate each value into one line then output
it in the report

Regards
Kelvan

 

[John W. Vinson]

Not even sure how to type this but I will give it a go
I have the following data.
Sku Plant WHS Contact Person
12345 11 AA Gary
12345 11 AA Tim
12345 11 AA Joe

What I want is to take the last column "Contact Person" and transpose the
data and then I want to concatonate the "Contact Person" into the same field
(seperate by a comma if need be...)

End result will look like:
Sku Plant WHS Contact Person
12345 11 AA Gary, Tim, Joe

You'll need some VBA code:

http://www.mvps.org/access/modules/mdl0004.htm