Select query inside loop

[novice]

Hi All,

I have a select query which selects couple of fields in a table. These fields are used to insert in another table. I just want to know on how can i select and insert the records inside a for loop, which tranverses all the records in the table. Please let me know. Thanks.

 

[ajetrumpet]

you cannot use SELECT queries in VBA writing. use an action query: APPEND, UPDATE, etc...