Could some show me how to output a row of data vertically instead of horizontally.
Ex. 123456 (original)

final output

1
2
3
4
5
6

Not sure where you want to put the data into

Try if the following link helps

http://vbadud.blogspot.com/2007/03/t...cel-range.html
Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

When you say a row of data, do you mean that the values "123456" are in seperate fields, like

Col1 Col2 Col3 Col4 Col5 Col6
1 2 3 4 5 6

Or that the data is all in one field, like this

Col1
123456

Or some other configuration?

Also, when you say "output", what format is that? Datasheet or Report?



mmcdonal

Look it up at: http://wrox.books24x7.com

The values 123456 represent separate column, like

Col1 Col2 Col3 Col4 Col5 Col6
1 2 3 4 5 6

I would like to store the in a text file.

So I am assuming then that you have some sort of method of retrieving one row of data to output to a text file. Is that a query, or are you taking parameters from a form, and then retrieving the data, and then outputting it to a text file?

Where do you want the text file saved, and what named? Or will you allow the user to chose the location and the name?



mmcdonal

Look it up at: http://wrox.books24x7.com

I have query that generates a table with the row of data. A second query saves the info to a text file.