Update Query Xfered from Access 2007-2010 now non-functional.

[gdpoc]

I have the following query (QRYTableSync2) updating the records in a table I use to populate a file browser.

UPDATE TBLFileList INNER JOIN QRYTableSync1 ON TBLFileList.FileID = QRYTableSync1.FileID SET TBLFileList.LastName = [QRYTableSync1].[last], TBLFileList.Last4 = [QRYTableSync1].[last4]
WHERE (((TBLFileList.FileID)=[QRYTableSync1].[FileId]));


Structure for the table
(Key) FileId (AutoNumber)
FName (Text) (The file name with file extension)
FPath (Text) (The file path)
DateCreated (Date/Time)
TBLStuForeignKey (Number) (Used to reference another table)
LastName (Text)
Last4 (Text)

SQL for QRYTableSync1
SELECT Left(Mid([TBLFilelist].[Fname],InStr([TBLFilelist].[Fname],'(')-4),4) AS Last4, Left([TBLFilelist].[FName],InStr([TBLFilelist].[FName],'(')-5) AS [Last], TBLFileList.FileID
FROM TBLFileList;


All of the files are formatted as such: LastnameLastfour(Stuff).
An example of this would be Hope5555(Allowances).
QRYTableSync1 is still functional and returns records accordingly but when I run QRYTableSync2 it returns nothing but blank records. This worked in access 2007 but now that the office has flipped to 2010 I'm experiencing issues with this tool. Does anyone have an idea why this particular query might have problems with access 2010?



Edit: I wound up cleaning up the queries and combining the two and it works. I'm still curious as to why though. Does anyone know why that particular set of queries worked in 2007, but not in 2010?