1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

query must have at least one destination field?

Discussion in 'Business Applications' started by bluebloods, Mar 20, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. bluebloods

    bluebloods Thread Starter

    Joined:
    Oct 2, 2004
    Messages:
    209
    what is that supposed to mean?
    im trying to make an append query but this message comes up :confused:
     
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,532
    You did not add fields to the query design grid, when you started to create the Append table you would have selected which table was going to be appended by the query. After that you need to add which fields are going to Append to that table. then if the query contains the same field names as the table it will automatically populate the "append to" otherwise you will need to use the dropdown to select the appropriate field.
     
  3. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,731
    If you do not want to append (add records to) another table, then change the query type to (probably) "select".
     
  4. joed202902

    joed202902

    Joined:
    Mar 7, 2005
    Messages:
    80
    bluebloods,

    I highly recommend you make a copy of the table to which you want to append records....experiment with the copy 1st. Also, make sure you have selected the Append Query from the tool bar. Then yes, you must define at least one destination field which is where the data will go.
     
  5. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,731
    Nice, joed. I often forget the cautions...
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/343674