Forum home » Delegate support and help forum » Microsoft Access Training and help » Append Query
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Append Query
Resolved · Low Priority · Version 2003
Reply Tue 6 Jan 2009, 14:49Delegate Tamsin said...
Tamsin has attended:
Access Intermediate course
Append Query
Can you be selective about which fields you include in an append query or do you have to take all fields in a table?
For upcoming training course dates see: Pricing & availability
RE: 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
Fri 16 Jan 2009: Automatically marked as resolved.
|