Error when running qry!

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!
 
M

Michel Walsh

Hi,


DELETE DISTINCTROW tblName.* FROM ...


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Problems 1
Blank shows in combo when there is an excluded record 2
Slow reports 1
DELETE QRY issue 4
"Aggregate" error when running query 3
Error message when deleting with attached SQL Server view 4
Making a Delete Qiuery from an unmatched Query 3
Deleting Unmatched records 3

Top