Charlotte has attended:
Access Introduction course
Access Intermediate course
Microsoft access
Please can you tell me when you would use an append query
What is the Append Query
An Access Append query adds (appends) records from one table to another table in the database.
The table that you want to append records to must exist. You can append records to a table in the database you are working in, or into another Microsoft Access database.
Access Append queries are good for adding data to a different table, where the data is based upon a selection criteria.
However, append queries are not always the most efficient way of adding records. If you need to add all records and fields from one table to another table, using Copy and Paste options would be the best solution.
Hope this helps.
Carlos
