[AccessD] Interactive Query Question

I have a make table query in a database. Each time I run this I have to go
into design view and change the name of the table the query writes to. Is
there a way in the query or in VBA to insert a table name interactively. I
cannot seem to think of one. Thanks.

===========I don't think you can with a fixed query. You'd need code. 

Susan H.