In Access I have a table that I want to copy data from, to a new table and then delete the data in the original table using a macro. I’ll need to do this multiple times. So I’ll need to copy to tblScansVote1, tblScansVote2, etc.
The original table is tblScans.
The situation is that I’m counting ballots. Each time we take a vote, we will scan the results into tblScans. After I’ve run queries and reports based on the data in tblScans I want to save the raw data as tblScansVote1, then after the second vote, save the data as tblScansVote2, etc. So that if anyone has a question on the results, we can go back to the original data to look. Kinda like an archive of each of the times a vote is taken.
Thanks for your time.