Delete

Delete records from one or more of the tables listed in the FROM clause that satisfy the WHERE clause (SQL).

Syntax
      DELETE [table.*] FROM table WHERE criteria

Key
   table     The name of the table from which records are deleted.

   criteria  An expression that determines which records to delete.

Example

'In SQL
DELETE * FROM Employees WHERE Title = 'Trainee';

' In VBA 'Open a database
Set dbs = OpenDatabase("C:\demo\Northwind.mdb")
' Delete employee records where title is Trainee.
dbs.Execute "DELETE * FROM Employees WHERE Title = 'Trainee';"
dbs.Close

“To finish a work? To finish a picture? What nonsense! To finish it means to be through with it, to kill it, to rid it of its soul, to give it its final blow the coup de grace for the painter as well as for the picture” ~ Pablo Picasso

Related:

Insert - Add records to a table (append query).
Select - Retrieve data from one or more tables or queries.
Update - Update existing field values in a table.
DCount - Count the number of records in a table/query.


© Copyright SS64.com 1999-2014
Some rights reserved