Append Query

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
 
J

Jeff Boyce

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".
 
Top