I am haveing the biggest problem. I have been working on this issue for a week now. I have a make table query that runs no problem. Then I am appending that data into another table. The table that I am appending to is EXACTLY the same as the make table. All that I am doing is moving all the data to a working table (this is neccesary). There is no primary key or validation rules. The problem is that when I append the data I keep getting an error that 95% of the records will not append because of a validation rule violation. I then tried to copy the data and paste it in the table and it worked. PLEASE HELP!