append and delete query showing different results

[ali32uk]

Hi All

this is really confusing and me and cant figure the reason..

I have 2 queries - an append query and a delete query, they are exactly the same other than the type (append/delete) I even copied the append query and just changed the type once copied...

So my question is why are they delivering different results, the delete query returns 130K less records....

SQL - Append
INSERT INTO TBLSystemImportFinal ( RS, MPN ) IN 'D:\MatchedFinal.accdb'
SELECT TBLSystemImportCross.RS, TBLSystemImportCross.MPN
FROM TBLRSOfferCross INNER JOIN TBLSystemImportCross ON TBLRSOfferCross.CrossRS = TBLSystemImportCross.Cross
WHERE (((TBLSystemImportCross.RS) Is Not Null));

SQL - Delete
DELETE TBLSystemImportCross.RS, TBLSystemImportCross.MPN
FROM TBLSystemImportCross
WHERE (((TBLSystemImportCross.RS) Is Not Null));

Your help would be much appreciated!

Ali

 

[dhookom]

One query has two tables in the FROM and the other query has only one.

Duane
Hook'D on Access
MS Access MVP

 

[jedraw]

With a DELETE query, you DELETE RECORDS NOT Fields.