Append queries in microsoft Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what do i do in access as it keeps on saying can not find out put table as i
have an append query that i have built and it cant find a table please help
would be much appreciated
 
Claire

This message could happen if you've not specified where the data is to be
appended.

Consider posting a copy of the SQL statement (change the view to SQL, copy
and paste the SQL).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
what do i do in access as it keeps on saying can not find output table as i
have an append query that i have built and it cant find a table
Click to expand...

Open the Query in Design Mode and open the Properties window (View,Properties)
Ensure that the "Destination Table" (and Destination Db) are correct.
-or-
Use the menu (Query,Append Query...) to set the values described above.
 
Back
Top