append records to another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Updating inventory levels 0
Error trapping in Access 2002 3
VBA: How can I use a string variable as autofilter criteria? 4
Master Table for Import only 3
How to setup database to make transactions (transfers) between two bank accounts 0
Filter Date field in a Query 2
Copy Master and Sub record to an exisiting record with specified P 30
Pasting cell contents into a macro 1

Back
Top