Pull records from table and put them in another

  • Thread starter Thread starter Helen
  • Start date Start date
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.
 
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.
 
Back
Top