Create an access table based on rows in another Access table.

[deevaetodin]

I am using a form to enter values in a one field table. What I then want to do is create a table whereby all of the row values now represent a field in a new table.

For example; in a form you enter the following values into a one field table 1,2,3,4,5 I now have 5 rows in one field. I now want Access to automatically create a new table that will have 5 fields titled 1,2,3,4,5.

Any help is greatly appreciated.

D.

 

[Reivaj73mx]

Hey let me know if you have not found this solution. I wrote this code like 3 years ago. If you have not found this code i'll post it next week

 

[deevaetodin]

Thanks for the reply.

I was not successful in getting this to work. Any help would be great.

D.