Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Access Training and help » Append Query
Resolved · Low Priority · Version 2003
Kieran has attended:
Access Intermediate course
Access Advanced course
When should I use an 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
Thu 17 Sep 2009: Automatically marked as resolved.
|
Access tip:Creating Parameter wildcard queriesTo creat a parameter query that also uses a wildcard, in the query design type in like []+*. |
We'll call during UK business hours
Server loaded in 0.08 secs.