Append or delete multiple records
I can select a record from a source data table by building a Recordset, then use the "Insert Record" wizard to insert selected fields into another destination table. But it only works one recordata time. How can I insert new records in the destination table for ALL of the records which satisfy the criteria in the recordset?