Make Table Query

A

angiebabe

Can some give me some simple instructions for a make table query.
want to use it to archive old records.

Thank
 
F

fredg

Can some give me some simple instructions for a make table query. I
want to use it to archive old records.

Thanks
Click to expand...

Create a normal Select query that returns all the records you wish to
send to the new table.
Then in Query Design View, click on Query + Make-Table query.
Answer the dialog prompt to name the new table. Click OK and run the
query using the Bang tool button.

Then you most likely will want to use a Delete query, using the same
criteria, to remove those same old records from the existing table.

But then, why send the old data to a different table.
Perhaps you should think about either adding a new field to the
existing table (a Check box is OK) or just use the existing Date
field, and either check those that are old and use a query to only
show current records, or use a query to only show records later than a
certain date. Much simpler to use this way, and all the data is
together if you ever want to go back into the older records.
 
A

angiebabe

Thanks so much for your response. The problem here that wil
necessitate a delete query is that there are many calculations tha
depend upon a date. For example, sales tax is calculated at 7% prio
to 2003, then went to 8%, and then went down to 7.5%. So unless I ge
those records out of the main table, when I change the calculaion t
read 7.5% sales tax, it will recalculate all the records (5,000+) a
7.5%, won't it?

thank
 
Top