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

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stirng from an array 5
Array with multiple results 4
transpose multiple rows into one column 2
Can I make a table of entries and run a query off of it? 1
Paste tab delimited data into separate fields 6
Import a comma delimited file & match records 3
Transpose into comma-delimited row 6
how to transpose multiple columns into rows? 7

Top