I'm using an update query to update a single field in a table. Table1 is part of my normalized table structure. Table2 is used solely as an import table for raw data which I sort and summarize through queries and VBA routines.
Table I'm updating looks like this
Table1
Code Name
1 Gym
2 Math
3 English
Table I'm using for update looks like this
Table2
Code Name year
1 Physical Ed. 2007
1 Physical Ed. 2007
1 Physical Ed. 2007
1 Gym 2005
1 Gym 2005
My update checks for the latest year and will update any Names in table1 where the Name is not equal to the name in Table2 with the same code. The update runs fine and gym will be updated to Physical Ed. in table1 however it will say it's updating 3 records instead of one. Does the query actually update the same field 3 times? Or does it break once the first update executes?