I am trying to combine three tables into one Master table. I have been doing this through appended queries. I can get the first appended query to work but the next two do not work and I get a message that says "Access can't append all the records" and something about conversion failure and validation rule violation. I have check all the the fields to make sure they match but I still get the error. What can I do? Is there another way to combine the tables?