append query

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Append Query

Append Query

resolvedResolved · Low Priority · Version 2003

Kieran has attended:
Access Intermediate course
Access Advanced course

Append Query

When should I use an append query?

RE: 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 queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.08 secs.