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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy - 24 Sep 2004 23:50 GMT

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

Reply to this Message

Douglas J. Steele - 25 Sep 2004 01:20 GMT

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

Signature

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

> 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
[quoted text clipped - 5 lines]
> Thanks again!
> Kathy

Reply to this Message

Kathy - 27 Sep 2004 15:20 GMT

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

Reply to this Message

Jim Allard - 27 Sep 2004 22:01 GMT

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

> 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
[quoted text clipped - 4 lines]
> displaying it in the form would be easy.
> Kathy

Reply to this Message