Solved I think I need a delete query (1 Viewer)

swingline

Member
Local time
Today, 15:10
Joined
Feb 18, 2020
Messages
51
I have a temp table that I would like to remove rows from if the value of one of the columns matches a query result.

SQL:
DELETE Task_Temp.*, CompletedTask.TaskNumber
FROM Task_Temp, CompletedTask
WHERE (((CompletedTask.TaskNumber)=[Task_Temp].[TaskNumber]));

If I view that in the datasheet view I only see matching Task as expected. But if I try and run the delete query it gives the error "Could not delete from specified tables" I feel like am missing something simple in this process.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:10
Joined
May 7, 2009
Messages
19,175
DELETE Task_Temp.*
FROM Task_Temp
WHERE [TaskNumber] In (SELECT [TaskNumber] From CompletedTask);
 

swingline

Member
Local time
Today, 15:10
Joined
Feb 18, 2020
Messages
51
Thank you!
 

Users who are viewing this thread

Top Bottom