Error when running qry!

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hi, I'm trying to run a del query. When viewing the
results before running in Datasheet view, it seems it
works ok. But when clicking the Run icon this message is
desplayed:

SPECIFY THE TABLE CONTAINING THE RECORDS YOU WANT TO DELETE

SQL Code:

DELETE tblName.NameID
FROM (((tblName LEFT JOIN tblTRAdmin ON tblName.NameID =
tblTRAdmin.NameID) LEFT JOIN tblTRPrj ON tblName.NameID =
tblTRPrj.NameID) LEFT JOIN tblTRSales ON tblName.NameID =
tblTRSales.NameID) LEFT JOIN tblTRService ON
tblName.NameID = tblTRService.NameID
WHERE (((tblName.NameID) Not In ([tblTRAdmin].[NameID])
And (tblName.NameID) Not In ([tblTRPrj].[NameID]) And
(tblName.NameID) Not In ([tblTRSales].[NameID]) And
(tblName.NameID) Not In ([tblTRService].[NameID])));

Thx in advance!
 
Hi,


DELETE DISTINCTROW tblName.* FROM ...


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top