Delete Query - deleted next 100 records

B

Bonnie

Hello,

Can you tell me how to delete the next 200 records. These could be any
random records - just want to delete 200 records with a query.

Thanks.
Bonnie
 
V

Van T. Dinh

It is a rather strange requirement but a Delete Query with SQL String like:

DELETE *
FROM [YourTable]
WHERE [YourTable].IDField IN
(
SELECT TOP 200 Sub.IDField
FROM [YourTable] AS Sub
);

should do what you want.
 
Top