Mass Update

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

Anthony Viscomi

I have 2 tables tblAccount & tblTransactions; tblAccount is related to the
tblTransactions via the AccoutID. I would like to add 1 new transaction
record for each AccountID within the tblAccount. Essientally, this is a rent
tracking DB the Tenants are stored within the tblAcount they all should pay
on a weekly basis and their $ amount is the same, thus a "mass update" would
be ideal. How can I achieve this?

Thanks,
Anthony
 
Sounds like a basic Append query. First, create a regular
query of tblAccount. Add the AccountID to the query and
any other fields, expressions (Calculations or text
strings) or selection Criteria you want.

When you are satisfied with the records the query displays
(essentially automatic transaction records), change it to
an Append Query and select the append to table to
tblTransactions. You will need to tell the query fields
and expressions will map to which fieds in
tblTransactions. Everytime you run the query it one
append 1 transaction to your tblTransactions table per
account.

You can accomplish the same thing programatically by
manipulating the recordsets.

Hope that helps. Good luck.

Kevin
 
Thanks!
Kevin11 said:
Sounds like a basic Append query. First, create a regular
query of tblAccount. Add the AccountID to the query and
any other fields, expressions (Calculations or text
strings) or selection Criteria you want.

When you are satisfied with the records the query displays
(essentially automatic transaction records), change it to
an Append Query and select the append to table to
tblTransactions. You will need to tell the query fields
and expressions will map to which fieds in
tblTransactions. Everytime you run the query it one
append 1 transaction to your tblTransactions table per
account.

You can accomplish the same thing programatically by
manipulating the recordsets.

Hope that helps. Good luck.

Kevin
Click to expand...
 
Back
Top