Make smaller tables out of a bigger one

I have a table with 3 fields. The fields are down1, down2 and down3. . I would like to use this table to create a new table (downtime). What I need too do is loop through each record in the table and place the three fields independently in my new table. For example, I would like to go to the first record in my original table, than place down1 as my first record in my new table, down2 as my second record and down3 as my third. Than I will go to the second record in my original table and place down1 as my fourth record, down2 as my fifth record, down3 and my sixth record and so on. Does anyone have code to do this? I want to make a toggle button that will do this.
Ps. I asked this question yesterday and thought I found a way to solve the issue but I realized that I didn't. Thats why I am asking the question again.

Hello Babak, I am sure this could be possible..But the truth of the issue is, WHY? What is the need for such a new table?

Should be easy enough using 3 Append Queries; one for each Down? and then Append the values to your New table field.

Thats a good idea ted let me try to see if it work!

Worked perfectly thanks alot!

pr2-eugin said:

Hello Babak, I am sure this could be possible..But the truth of the issue is, WHY? What is the need for such a new table?

Click to expand...

Paul, I'm surprised that you asked that question.

"The fields are down1, down2 and down3."