I want to make a copy of a table and keep only the current record. I need to extract this information to fusion it in word. Am I better with copying the whole table and deleting what I don't need? Should I create a new table and all the fields and then copy the record I need? Is there a way of saving the current record of a recordset as a record in a new table?(that would be the best way to go if possible!) I uses Access 97.