Select and delete a record

  • Thread starter Thread starter Luis Marques
  • Start date Start date
I need a code to select a record in a table and delete it.

Could you help me?
Click to expand...

Create a new query in the Query design window. Base it on the table; apply
whatever criteria are needed to select the record that you want to delete.
Change it to a Delete query using the Query menu option or the query type tool
in the toolbar.

Run the query and the record will be deleted. BACK UP YOUR DATA first - if
your query deletes 81224 records instead of the 1 you want, there's basically
no way to get them back.
 
Back
Top