Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Strange Update Query Error

Author  Topic  ddans Starting Member 2 Posts Posted - 2006-08-15 : 14:06:10 was wondering why i'm getting an error saying this isn't an updateable query, PARAMETERS [spSubSystemHours] Text ( 255 ), [UserEntry] Text ( 255 ); UPDATE tblSubSystem SET tblSubSystem.SubSystemHours = (((SELECT tblSubSystem.SubSystemHours FROM tblSubSystem WHERE (tblSubSystem.SubSystemDetails)=[spSubSystemDetails]))+UserEntry) WHERE (((tblSubSystem.SubSystemDetails)=[spSubSystemDetails])); I made this query so that I can use it in a vb.net program I have where I want to update subsystemhours by adding a number entered by the user in the program. If anyone sees what I've done wrong, please help. Thanks alot.