Delete Query - deleted next 100 records

[Guest]

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

 

[Danny J. Lesandrini]

Well, I haven't had occassion to try this, but how about using the TOP
operator? The sql would look like this, if it is supported ...

DELETE TOP 200 FROM tblOoops

or maybe in Access it needs to look like this ...

DELETE TOP 200 tblOoops.* FROM tblOoops

 

[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.

 

[Van T. Dinh]

Danny

I tried the TOP predicate in a Delete SQL and JET doesn't like it. Hence,
my suggestion of the SubQuery.

 

[Danny J. Lesandrini]

Thanks

I didn't have the patience to test it myself