The subquery SELECT Rank.Rank_Name FROM Rank is probably returning more than one record because you aren't doing any filtering on it. You can't use a subquery that returns multiple values in most areas of a query. This query also looks like it is circular. You seem to be trying to set the Users Rank to the Rank_ID that the User already has.
Can you explain in words what you're trying to do with the query? We can probably sort it out then. Cheers, Judah On Thu, Jul 29, 2010 at 9:09 AM, Bruce Sorge <sor...@gmail.com> wrote: > > OK, so I have been out of the game for a bit and my platoon sergeant wants > me to build an MS Access form for our platoon info. So I am trying to do a > simple update query and I get the message Operation must use an updateable > query. Here is the query: > > UPDATE Users > SET Users.User_Rank = (Select Rank_ID FROM Rank > Where Users.User_Rank = > (Select Rank.Rank_Name > FROM Rank)); > > This is for MS Access 2003, Can anyone see what is wrong with this? As I > said, I have been out of the game for a couple years and am a bit rusty. > > > Thanks > > Bruce > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:324086 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
