can an update query generate an append query

[jalewis999]

The first part is simple. Members have two types of bank account. So I need to search the member records for certain parameters, move some of the balance from one account to the other. This is a simple update query. Is it possible to create a transaction record using some of that records data on the one pass. There might be thousands of transactions. My only other choice seems to be, find a record, update, then append the transaction table.


Thank you for any help.

[ranman256]

Run 2 queries. Macro, or vb.

[jalewis999]

Run 2 queries. Macro, or vb.

But i will need info from each record updated.

[Micron]

See if what's referred to as an Upsert query will do the trick. It depends on your tables and records whether or not you can use it.

[jalewis999]

See if what's referred to as an Upsert query will do the trick. It depends on your tables and records whether or not you can use it.

It seems like it is an either or on the same table. I need to add a row into another table (Transactions) as each qualifying member record is found.

[accesstos]

Please review this:
https://docs.microsoft.com/en-us/off...-dao-recordset

[isladogs]

See if what's referred to as an Upsert query will do the trick. It depends on your tables and records whether or not you can use it.

AKA Upend query. For more details, see http://www.mendipdatasystems.co.uk/u...ery/4594428616

[jalewis999]

Please review this:
https://docs.microsoft.com/en-us/off...-dao-recordset

Good to know but not what I need. I'm doing an update query anyway. I'm looking for a method of inserting into the transaction table immediately after the update. Update member insert a new transaction. All in one query or sql statement.

[isladogs]

Good to know but not what I need. I'm doing an update query anyway. I'm looking for a method of inserting into the transaction table immediately after the update. Update member insert a new transaction. All in one query or sql statement.

That is what the upend/upsert query does. Did you look at my link?

[RandyH]

I'm not a programmer, but I've done a lot of programming on my system.

When I needed what you are describing I did this because it was all I knew.



My Update Command Button

On Click

.Execute "Update Qry",
.Execute "Append Qry",




Didn't use any db Error code Because I didn't want to click through the standard warnings.


Of course there is more code the end this!