query design help needed

  • Thread starter Thread starter Gary F Shelton
  • Start date Start date
G

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.
 
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
 
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
Click to expand...

You'll need some VBA code:

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