Help required

[Bobby]

How can I transfer cancelled records, which I wish to
retain, to another table?

 

[BerHav]

Hi,

If you add a field to flag cancelled records use an append query to copy the
flagged trades to another table and if wanted a delete query to delete the
flagged ones in your source table.

Bernd

 

[Jeff Boyce]

Why? As in "why move the records around?" You already have a lead to a
solution in the other response to your question.

Add a "flag" field to indicate that a record is cancelled, then modify your
queries to exclude "cancelled" records. All the data stays in place, and
you can, if you need to, easily look up ALL records without having to look
in more than one table.