Append Query

Hello Kieran

Thank you for your question and welcome to the forum.

An append query adds a group of records from one or more tables to the end of one or more tables, so it is used to update/add new records to an existing table.

For example, suppose that you acquire some new customers and a database containing a table of information on those customers. To avoid typing all this information into your own database, you could append it to your existing Customers table.

Kind regards
Amanda