Update Query not updateable? (1 Viewer)

[MARKYB0Y]

Hi,

I am trying to run a query to update all the teamnames in the scores table to be the same as whatever teamname is in ID1 slot

the select statement runs fine on its own so it must be something in the syntax
also, UPDATE [Scores] SET [Scores].[Teamname] = "anything" works just fine

UPDATE [Scores] SET [Scores].[Teamname] = (Select [Scores].[Teamname] FROM [Scores] where [Scores].[ID]=1)

I use SQL normally and would use "update TABLE set COLUMN=(Query)" and it would be fine, is Access 2007 looking for a different set of parameters?

thanks in advance of assistance

 

[Jon K]

Try using DLookup() instead of the subquery.

UPDATE Scores SET Teamname = DLookup("Teamname","Scores","[ID]=1");
.