Append Query

  • Thread starter Thread starter mrz via AccessMonster.com
  • Start date Start date
M

mrz via AccessMonster.com

Hey

I trying to create an append query so I can add extra information into a
table. Everytime I run it I get a message that reads:

Query must have at least one destination field.

Can someone please explain this to me. Also please take a look at my
earlier posting title "COMPARING TWO QUERIES"

Thanks,
MRZ
 
An append query takes data from one table and adds it to another table. When
you change your query type to an Append Query, access changes the "Show" row
in the query design grid to be "Append To". You need to tell access how
fields from the source table match up with fields in your destination table.
If the field names are identical, access will figure it out, but if they are
not, you must perform this manually.

HTH
CJ
 
Back
Top