append records to another table

's Computer Specifications

Hi,

Any guidance would be greatly appreciated.

I want to query my Master List table with certain criteria. Using the
results of the query of Master List, I want to add a record to my
Transactions Table for each record record returned in the Master List Query.
Master List and Transactions both have an ID field. So, if Master List Query
returns 20 records, I will want to add a record to Transactions with ID being
the same as the ID in Master List. I will also be adding other fields to
each Transactions record as well. What is the best route to go?

Thanks again for any direction you can give me.

Sarah

's Computer Specifications

You could use a DLOOKUP to query your Master List Table and store th
appropriate values as variables, then use an SQL INSERT statement t
add the appropriate record to your Transactions table

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append records from table in unsecured db to table in user level s	=?Utf-8?B?RGVpcmRyZQ==?=	Microsoft Access Queries	3	7th Nov 2007 07:34 PM
How do I append records to a different table?	Frank Martin	Microsoft Access Database Table Design	3	26th Sep 2007 04:14 PM
How to append new records to the end of table	=?Utf-8?B?TWluZw==?=	Microsoft Access Queries	5	8th Jun 2006 09:35 PM
Can I add records in parent table during daughter table append?	=?Utf-8?B?UGV0cm9DaHJpcw==?=	Microsoft Access Queries	6	13th Aug 2005 10:30 PM
Paste Append - I want to make a table of records that don't append	=?Utf-8?B?Q0o=?=	Microsoft Access Queries	1	5th Jul 2005 06:35 PM