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

swingline

Member
Local time
Today, 16:14
Joined
Feb 18, 2020
Messages
49
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

error reading drive A:
Local time
Today, 21:14
Joined
May 7, 2009
Messages
10,844
DELETE Task_Temp.*
FROM Task_Temp
WHERE [TaskNumber] In (SELECT [TaskNumber] From CompletedTask);
 

swingline

Member
Local time
Today, 16:14
Joined
Feb 18, 2020
Messages
49
Thank you!
 

Users who are viewing this thread

Top Bottom