I have an append query that send information into a table that has unique identifiers on two fields. It posts say 45 out of 50 records from the main table. Is there anyway to at the same time have the rejected 5 records sent to a different table? What options are there out there?
thanks
thanks