Rick has attended:
Access Intermediate course
Access Advanced course
Appending queries
When I tried to run an append query I selected my table to take entries from, but the table I wanted to append them too was not available on the list. When I reversed the process, switching the tables around it worked perfectly. Numerous attempts and fiddling later, I could not work it out.
RE: Appending queries
Dear Rick
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
This problem could be because of several reasons and I have researched on the web for a while now to see what could be the best possible reason for this problem.
I managed to come across the following link. I know that the thread to this link is quite long but it provides you with many possible solutions that could rectify the problem. Just keep on pressing the RE: thread to see the reply to the post. If you have problem understanding how to navigate through these posts then please let me know.
http://www.eggheadcafe.com/conversation.aspx?messageid=31880830& ;threadid=31880830
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
