Copy specific data to another table

[shei]

I am currently developing an inventory database. The items usually are consigned to a shop and then it's either returned to the head office and it will be consigned again to another shop or it will be sold. Is there a way that I can transfer all the sold items to a new table without fearing that the others will stay on the movement table?

[RealisticGraphics]

try to use an sql statement similar to the following:


Select * Into SoldItems from MyItems where IsItemSold = 'True'