Deleting Records

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

Gerrym

I want to use a delete query to delete the first 12
records in a table, can I do that. I cannot set a
criteria based on field content, just the first 12 records
 
Gerrym,

Yes, you can, by utilizing the TOP VALUES property of delete query,
***BUT*** unless you can sort on specific field(s) in the query, you
will have no control over which12 records will be deleted.

Records in a table are not sorted (even if it may seem that way when you
view the table, if there is a primary key), so deleting the first 12
without specifying a sorting order gives you no control over which
twelve records will be deleted.

HTH,
Nikos
 
Back
Top