How to quickly update all fields in a query?

[Brianwarnock]

Nothing wrong with your suggestion, but it obviates the need for an update query at all. You could just delete and append every time something changed and never use an update query.

I'm not sure which is more efficient, but the query runs very quickly for me.

Thanks again for your help.

Why are you so desperate to have an update query, you are updating ALL of the fields, so why not work at the record level.

Brian

 

[Sum]

If designed properly and normalised the fields in a table, which is what we are talking about here, should rarely change.

Brian

Really?

So if we decide to begin tracking Performance and Potential for Store Managers, I wouldn't have any reason to update the fields in my succession planning table to include those variables? I should have known that in advance when I first designed the query?

 

[jdraw]

I've arrived late on this and have just scanned the posts. Brian's delete the Master record and append the "revised" temporary record is very akin to transaction processing logic for recovery after a failure.

I don't see why there is not an Update query template, if you will, to Update the master. However, I see nothing wrong with the delete and append approach.

It's possible there is a lot more detail to this database/application than has been written in these posts. It does sound like there may be some new queries/statistics re performance in the near future.