Using a command to rename an exisiting table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db that I use to run some monthly reports. I also produce some
trend reports using previous months data. I am trying to place a button on a
from that will allow the user to run a make table query for the new months
reports. But before this happens, I want to be able to save the previous
months table so that I can reference it for the trending. The only way that
I can think of doing this would be to writed twelve seperate make table
queries that would run based on the current date. Is anyone aware of any
quicker or easier way to do this using code that would rename the old table
and then run the new query? Thanks in advance.
 
Why a separate table for each month? Just identify the records with a date
and then pull data for reports based on dates.
 
There is no existing date for the records, in addtion to the fact that the
tables are 10's of thousands of lines long as I bring them in. And it is
possible for a record to span a month, but I cannot use unique records
because it is possible for a record to appear twice in the same month and I
need to be able to count its occurance. I have already setup the VBA to run
12 different make table queries based on the date they are run. I was just
trying to simplify the process and the amount that I had to key. Thanks
 
Back
Top