>Hi,
>
>List of fields in one continuous line :
>
>AA,BBB,CCCC,DDDDDD,EEEEEEE.......
>
>to get into a table1 :
>
>field1
>
>AA 1 record
>BBB 2 record
>CCCC 3 record
>DDDDDD 4 record
>EEEEEEE 5 record
>.
>.
>
>Any help in coding would be appreciated very much?
>
>PP

Paul,

Are you trying to take a table and turn the columns into rows? If so, look into CrossTab which works off of a primary field. I'm a little confused with your example as you grow the fields from "AA" to "EEEEEEE" and I'm not sure what that means, if anything.

Renoir