I have a table by name payments, which keep records of all members payments and i have created another table called Rpay with the same fields as the payments table. In the payments table there are duplicate records since one member can pay his contribution many time in a given year, I want to append from the payments table to the Rpay table each record so that my Rpay table will not have duplicates records.