Can anyone help
I am trying to use a non - updatable query to filter records on a table and then update the resulting records of the table but I get the message "operation must use an updatable query"
I have posted the SQL below
UPDATE [Application Report CAP Query E Table 1] LEFT JOIN [Cost Authorisation Table] ON [Application Report CAP Query E Table 1].[Cost Auth ID] = [Cost Authorisation Table].[Cost Auth ID] SET [Cost Authorisation Table].[Application Approved Count] = 1;
Application Report CAP Query E Table 1 is the non - updateable query
Any help would be really appreciated
Thanks
I am trying to use a non - updatable query to filter records on a table and then update the resulting records of the table but I get the message "operation must use an updatable query"
I have posted the SQL below
UPDATE [Application Report CAP Query E Table 1] LEFT JOIN [Cost Authorisation Table] ON [Application Report CAP Query E Table 1].[Cost Auth ID] = [Cost Authorisation Table].[Cost Auth ID] SET [Cost Authorisation Table].[Application Approved Count] = 1;
Application Report CAP Query E Table 1 is the non - updateable query
Any help would be really appreciated
Thanks