moving records from table to table

[Guest]

i need to know a simple way to move a record from 1 table and place it in
another table. both tables are set up identically, one table is an active
table, and the other one is an inactive table. i want to do this when a
yes/no field is changed to no, signifying to move the record to the inactive
table.

 

[tina]

you can use an Append query to add TableA's record to TableB, and then a
Delete query to delete the record from TableA. suggest you consider whether
it's really necessary, though. you can easily keep active and inactive
records in one table, with a Yes/No field to designate the records as one or
the other. by doing this, you can easily switch between working with
(reviewing, or whatever) active/inactive records, using a single interface.

hth

 

[Joseph Meehan]

i need to know a simple way to move a record from 1 table and place
it in another table. both tables are set up identically, one table
is an active table, and the other one is an inactive table. i want
to do this when a yes/no field is changed to no, signifying to move
the record to the inactive table.

Usually it is far better to just use one table and add a binary (yes no)
filed and use it it ID archived records.