You can use an unmatched query it is one that is provided int he wizard to determine what is in one table and is not in another. Then turn that into an append query for the new records.
If that doesn't work you can just do standard select query. force all records from the new sales to the old sales. Then where the ID is null on the old sales table you can append that to itself. That should work too.