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
 
Back
Top