Pull records from table and put them in another

H

Helen

I need to create a query that will pull records from a
table based on a date range, put them in another table
then delete them from the original table. Any help would
be appreciated. Thanks in advance.
 
F

fredg

Helen said:
I need to create a query that will pull records from a
table based on a date range, put them in another table
then delete them from the original table. Any help would
be appreciated. Thanks in advance.
Click to expand...

Helen,
You'll need 2 separate queries.
In Query Design View click Query + MakeTable Query
Make, and run, a Make Table query, using whatever criteria is needed to
select the proper records.

After successfully creating the new table, click Query + Delete Query.
Write, and run, a Delete Query, using the same criteria as the Make
Table query.
 
Top