Hello,
I got this error "Operation must use an updateable query"
I dont understand what does it mean please someone help me out with this.
Thanks in advance.
Hello,
I got this error "Operation must use an updateable query"
I dont understand what does it mean please someone help me out with this.
Thanks in advance.
check this out: http://support.microsoft.com/default...;en-us;q175168
On which line you got the error?
Can you put your code please?
Is it access SQL?
OK here it goes.
Code:UPDATE [Data Extract] SET [Data Extract].[Unit a] = (SELECT [Unit c]![Unit b] FROM [Unit c] WHERE [Unit c]![Country] ="Not Listed") WHERE ((([Data Extract].[Unit a]) Is Null));
Using a subquery in an update query is not allowed.
instead do this.
Code:UPDATE [Data Extract] SET [Data Extract].[Unit a] = DLookup("Unit b","Unit c", "Country ='Not Listed'") WHERE [Data Extract].[Unit a] Is Null;
Bookmarks