Quote Originally Posted by lienlee
where would i use this update in access?
and these are my two tables..

thanks btw
That's a tough question. But ultimately it comes to a factor of need. When do you need the update to be performed. I have assigned Update queries on startup, or macros to be run at user determined times.

Since you are in 2007, you could assign it to a macro and place it in the ribbon so whenever you need it you can just go into the ribbon and click it.

You tell me when you need it, I'll tell you how to get it there.

Out of curiosity, these tables look identical, not just that they have some of the same data shared. They have all the same data. What is the difference in functionality and would one table not be able to perform the same functionality?