Don't forget the ";" at the end of the statement. Glenn P. Jones
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly Sent: Wednesday, 17 August, 2005 12:28 PM To: [email protected] Subject: Re: [AccessDevelopers] Must Use an Updateable query I think it is because you are running a subquery on the same table that you are trying to update. Also, I think you have to include the second table in the from clause in the subquery (or else JOIN the second table ON those two fields). I might try using a temporary table to dump the subquery results into, and then run the update against. HTH, Toby ----- Original Message ----- From: "bitschon" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 16, 2005 6:13 PM Subject: [AccessDevelopers] Must Use an Updateable query > This innocuous query: > > sql = "update po_status " & _ > "set po_late = (select po_count " & _ > " from po_late pl" & _ > " where pl.po_id = po_status.po_id " & _ > " and pl.class_code= po_status.class_code) " > > is causing the "must Use an Updateable Query" error > > How does one get around this? > > Thanks > > JPS > > > > > > > Please zip all files prior to uploading to Files section. Yahoo! > Groups Links > > > > > > Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h30b97b/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124306588/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
