Append table

Dear Pauline

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

When you append records from one table to another it is important that both the tables should have the same fields. Normally the main purpose of append query is to copy and paste new records from one table to another.

If you have primary key in your tables please ensure that the data doesn't duplicate otherwise the Append query will not work.

If you can provide a more specific example as to what you want the append query to do then I should be able to look into it more thoroughly.

Meanwhile the following link should be of some help to you:

http://office.microsoft.com/en-us/access/HA100765261033.aspx?pid=CH100645771033

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007