move records from table to new table

[micromoth]

Hi all, I have a table with 3000 records in it, I have created a query
which gives me 70 (inactive customers) records. I would like to
remove these records into another (duplicate format) table for
storage. The original table uses Autonumbers as the Primary key
(which may be relevant).

Another way of describing this would be selectively archiving
records. It is unlikely that I would need to restore an individual
record, but this would be good if possible.

Can Access do this?
What is it callled (jargon)?
Does anyone have instructions?

Cheers and thanks in advance, Graham

 

[KARL DEWEY]

It would better to add an Archive field and then in your queries have
criteria to not pull archived records. Then the records are there for use
even if you need history and current records in the same query.

 

[Jackie L]

I agree with Karl.

You could add a new field to your table (Yes/No type), create a new Update
query where you have the table linked to your existing query (the one that
determined which records should be archived) by the primary key and update
the new Archive field to true.

Hope this helps,
Jackie