DELETE QUERY QUESTION

[blindlemonray]

Can anyone help. I have an sql statement which is

SELECT TOP 1000000 C2.*
FROM CONTACT2 C2
WHERE (ACCOUNTNO = '')

But what I would like to do is delete these records as well. I know you cannot use the top statement with delete query!!

Has anyone got any ideas!!

Thanks in advance

 

[mp9]

Use a make-table query based on your Top query to create a temporary table.

Then use a delete query to delete the records in your orignal table where there is a join to the temporary table by common primary key fields.