Solved I think I need a delete query

[swingline]

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.

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]

DELETE Task_Temp.*
FROM Task_Temp
WHERE [TaskNumber] In (SELECT [TaskNumber] From CompletedTask);

 

[swingline]

Thank you!