I have a SELECT query whose results I need to INSERT into another table. Currently I have made the query an Insert query but this makes testing and development difficult. Most times I just need to browse the records returned without inserting them as they already exist in the target table. I have kept a separate copy of the query as SELECT but keeping them both updated is also demanding. Is it possible to use an INSERT statement with Currentdb.Execute and pass the SELECT query as an argument/parameter instead of individual records?