I know this will seem strange, but I want to use the PK and delete all
records with a primary key >= the record that I search for and find.
I am importing an Excel spreadsheet with some weird data and when it is
imported, the PK is added in sequence of the rows, of course. I then am going
to search for specific text that exists only in one record, and then delete
that record and all records after that record.
The reason is that the rest of the field values in the records don't make it
possible to create a query criteria which I can use to eliminate the bad
records.
I am doing this in Visual Basic for Access.