Append Query

  • Thread starter Thread starter Aran
  • Start date Start date
A

Aran

I am very new to access so hopefully there is a simple
answer, I have created an append query as I want to
archive certain records. The append query I have created
appears to copy ALL records from one table to another but
I only wanted to copy one record on screen at that time.
Is this possible?

Many Thanks

Aran
 
Aran

You may not need to copy any records. In many situations, the underlying
rationale for "archiving" a record/row is that you don't wish to see it
during normal operations. This does not require removing it from the table.

If you add a field to your table (a Yes/No) to indicate that the record is
archived, you can add a checkbox on your form, and modify your query on
which the form is based to display only those that are NOT archived.

This saves you having to figure out a way to get at records that had been
moved to another table. All the records are still in the same table -- it
only takes a change in the query to get the archived records "back".
 
Back
Top