I'm not sure why this update query returns thousands of records when I preview it in Access 2007 (and won't even finish executing if I run it) instead of a couple thousand like it's supposed to. I've done hundreds of queries like this before, and this query is not terribly complicated. Here is the SQL:
UPDATE Awards, FO SET Awards.Username = [FO].[Username]
WHERE [FO].[FullName] Like [Awards].[FullName] & "*";
Basically I just want to update the "Username" field in the "Awards" table with the "Username" field from the "FO" table where the "FullName" from the "Awards" table begins with the same beginning characters (last name and first name essentially) as the "FullName" from the "FO" table. So in other words the name "Smith,David" from the "Awards" table should match the name "Smith,David L." in the "FO" table (hence the "LIKE" operator), it should then get the "username" from the "FO" table and update the "username" field in the "Awards" table.
This is very straightforward and I'm not sure why it won't work. The "Awards" table only has about 5000 records and the "FO" table about 2000. However when you preview the results the records are in the hundreds of thousands, so it obviously isn't working correctly. Any suggestions?