Access 2003

Dear Alan

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

It is possible to append fields even if they don't have the same field names.

When you convert your select query to an append query normally this query matches all the names that are same in the other table.

On the grid box you'll notice that Append to section appears and all the matching fields are automatically entered in this section. The ones where the field names are different you will notice that it leaves the Append to section blank. You have to manually select the field that it relates to in the other table and then run the query. This should be able to append the records.

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