Can you join Users and Rank? On Thu, Jul 29, 2010 at 12:09 PM, 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:324084 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
