Post the SQL of both queries - your 'select' and 'delete' query.

--
Build a little, test a little.


"SITCFanTN" wrote:

I'm running a delete query that removes the records from table tblAllRecords
when the PolNo is also found in a table called tblTransfer. When I run the
query as a select query, it identifies 281 records to be deleted. When I run
the query as a delete query, I get a messge box saying the query will delete
281 records from the table tblAllRecords, however after the query is run, I
have 7,481 less records in my tblAllRecords!! I have never expereinced this
before. What is happening? Any help you can give me is greatly appreciated.

I'm running this query against my tblAllRecords

Where
(Select [PolNo] FROM tblTransfer)