Need query to move existing (old query) to new query/table?

[Guitarzan]

I apologize for the title in advance, it's hard to sum up my issue. I have a table called "Customers". Each week I import an excel file into this table and replace the old data with the new data. I only want the new excel data in this table.

I have a query called "Current Customers" that is run on the table "Customers" to find out who is a current customer.



I want to have a query? or table? called "Last weeks customers" where it would take the data from the "current customers" from the previous week and throw them into this query/table.

In other words, I'll import the excel each monday, I'd like 2 queries to show the current customers and last weeks customers. Last weeks should be a snapshot of the query "current customers" from the time i ran it last week. Confused yet? lol I know I am.

[Guitarzan]

Ok so I added a create table query so when I open the db I can click the create table query and it will make a table of the customers from the previous week. Then i can import my data and run the current customer query and have both.

Is there any way to automate running the query upon launch of the db?

[June7]

A process that routinely modifies structure of db is usually not a good idea.

Instead of creating a table each week, just delete records from this intermediate table and import the new set.

Automate with an Autoexec macro or code behind a form set to open by default when the db opens.

[Guitarzan]

A process that routinely modifies structure of db is usually not a good idea.

Instead of creating a table each week, just delete records from this intermediate table and import the new set.

Automate with an Autoexec macro or code behind a form set to open by default when the db opens.

Thanks! Just did this and everything is working wonderfully.