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.

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.

THIS THREAD HAS EXPIRED.
Are you having the same problem?
We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.