I'm editing the sql for a query e.g
Set qq = CurrentDb.QueryDefs("Query1")
sql2 = qq.sql
I change sql2 then
qq.sql= sql2 and run it. It executes as expected.
But I find this rewrites Query1, but that is not what's wanted.
I want to run the edited query once but also keep the original.
How might this best be done ?