The Find Unmatched Query doesn't run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have created a Find Unmatched Query which list the correct orphan records in datasheet view.I must admit, that I am not well versed with MS Access so I don't know where I am going wrong
When I try to run, it gives me warning that this will modify the data in your table, are you sure? When I click yes, it says specify the table containing the records that you want to delete
Why is this happening
Here is Quer
DELETE [Cycle_Type1].[cycle_number], [Cycle_Type1].[cycle_project], [Cycle_Type1].[Cycle], [Cycle_Type1].[Cycle Type], [Cycle_Type1].[P_S_Date], [Cycle_Type1].[A_S_Date], [Cycle_Type1].[P_E_Date], [Cycle_Type1].[A_E_Date], [Cycle_Type1].[Planned_ Effort], [Cycle_Type1].[Actual_ Effort], [Cycle_Type1].[D_Critical], [Cycle_Type1].[D_Major], [Cycle_Type1].[D_Minor], [Cycle_Type1].[Enhancements], [Cycle_Type1].[Documentation Defects], [Cycle_Type1].[Core Stack Product/Valid behaviour], [Cycle_Type1].[Core Stack Product/Invalid behaviour], [Cycle_Type1].[Documentation category], [Cycle_Type1].[Load & Performance], [Cycle_Type1].[Porting & installation], [Cycle_Type1].[System management], [P_Detail].[Serial_no
FROM Cycle_Type1 LEFT JOIN P_Detail ON [Cycle_Type1].[cycle_project]=[P_Detail].[Serial_no
WHERE ((([P_Detail].[Serial_no]) Is Null))

TI
Shilps
 
You have field from TWO DIFFERENT TABLES in the DELETE clause. You can only
have one. Also, you only need one field in the clause to identify which table
you want to delete records from. The following should delete the records from Cycle_Type1.

DELETE [Cycle_Type1].[cycle_number]
FROM Cycle_Type1 LEFT JOIN P_Detail
 
Back
Top