Append Query

Dear Tamsin

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

Yes it is possible to be selective about the fields you want to append. Please remember that the table where the records have been appended to ignores the other fields and leaves them blank.

Following is the example of appending certain fields from one table to another:

Let