Create a table with a column for each record in a 1 column table

Create a table with a column for each record in a 1 column table

Post by Kath » Sun, 26 Sep 2004 07:50:26



Hi and thanks in advance for your help! I have Access 2000. I have
imported a delinited text file and now have table with one column
containing 100 records. I would like to display these values in a form.
I think what I must do now is convert my table with 100 records into a
table with 1 record and 100 columns. Is this correct thinking? Then how
do I do that? The column names are not important.

Thanks again!
Kathy


*** Sent via Developersdex http://www.yqcomputer.com/ ***
Don't just participate in USENET...get rewarded for it!
 
 
 

Create a table with a column for each record in a 1 column table

Post by Douglas J. » Sun, 26 Sep 2004 09:20:47

There's no reason you can't show 100 rows on a form.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)

 
 
 

Create a table with a column for each record in a 1 column table

Post by Kath » Tue, 28 Sep 2004 23:20:15


Yes, I need to explain farther. The from will resemble a display the
screens of a an application that monitors a thermoformer. So I am not
just trying to display data. Each of the 100 rows is a value in a
recipe. I must recreate that. So, I must put each "row" in a text box
arranged on a form to imitate the screen those values would be found on.
I thought it would be easier to turn the 100 rows into 1 row so
displaying it in the form would be easy.
Kathy


*** Sent via Developersdex http://www.yqcomputer.com/ ***
Don't just participate in USENET...get rewarded for it!
 
 
 

Create a table with a column for each record in a 1 column table

Post by JAllar » Wed, 29 Sep 2004 06:01:49

Hi,

I think the simplest method would be to take your data and stick it
into an excel worksheet - select the range (say A1:A100)and copy and
move to B1 and paste special - in the dialog select transpose - this
takes the column of data and makes it one row. then import that range
into access (a new table) - Voila, all done.

JimA