[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.

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.