Split query results

[voskouee]

I have a query and the results i want to split them into a new table. lets say the query has 8 fields.

A B C D E F G H

i want to append these in a table like this

1st row of the table = A B C D
2nd row of the table = E F G H

and it has to go trhouh the whole query for all the rows to do the same thing.

Thank you in advance.

 

[The_Doc_Man]

Two (new) tables = two new queries.

Write the ABCD query as an Insert to one of the proposed tables. Write the EFGH query as an Insert to the other of the proposed tables.

Divide and conquer is the key to understanding this problem. Break it up into simple parts. Then do the parts.

 

[suvarna]

Make two separate make-table queries.