Using Variable to Name Table

[Nicole]

I know this probably sounds strange, so hopefully my
explanation will help a bit. I am trying to automate a
process where I receive a table named "feedback" and have
to rename the table to "feedbacknnn" where nnn is the
next sequence number. This is done to keep a history of
the "feedback" table. I would like to automate this
process rather than have to manually rename or create a
new table each time. Is there a way that if I have a
variable or a field in another table that contains the
name I want to use, I can create a new table or rename
the current table using this variable/field data?
Thanks!!

 

[Adrian Jansen]

Sorry to disagree, but you are on the wrong track entirely. You should be
storing the new data, probably with a Date Recieved, in one table by adding
new records to it. Then just sorting or filtering by date will show all the
records for any history you want. You may want one table to temporarily
store the incoming data, but that should just act as a way of transferring
the data to your main table, and be cleared after each import.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Nicole]

Unfortunately I am a victim of the "we have always done
it that way" syndrome in this case, and I was trying to
keep things as they have been doing them with only minor
changes. However, this is definitely something I will
suggest as an alternative. Thank you!