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

[Kathy]

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.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Douglas J. Steele]

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Kathy" <Kathy.merecat.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

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.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Kathy]

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.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jim Allard]

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
Kathy <Kathy.merecat.com> wrote in message news:<41**********************@news.newsgroups.ws> ...

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.developersdex.com ***
Don't just participate in USENET...get rewarded for it!