transpose values from a one column table into a comma delimited ro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a one column table like this:

Document Number
123456
123457
123458

I would like to be able to transpose the document numbers so that they end
up like this
123456,123457,123458

This could either be exported to a text file or anywhere that I could then
copy and past the values into another piece of software.

Thanks in advance
 
Hi Joan

This worked really well. Thanks very much.

I do have one issue though - it works fine on my PC which has VB 6 installed
but when I put my database onto another PC which doesn't have VB 6 installed
I get an error when calling the module. Is there something I have missed?

Kind regards
Kathy
 
Back
Top