I have developed a make table query in order to create a back up table of some data. I nned to run this query on a regular basis and change the table name every time its ran.
One time it is tabel2000 the next time its ran is table2001. Is ther a way I could pass the nre tables name to the query as a parameter or could I just use an SQL statement to build the table, and if so how would I go about it.
One time it is tabel2000 the next time its ran is table2001. Is ther a way I could pass the nre tables name to the query as a parameter or could I just use an SQL statement to build the table, and if so how would I go about it.