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

      DELETE [table.*] FROM table WHERE criteria

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

   criteria  An expression that determines which records to delete.


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';"

“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


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 1999-2015
Some rights reserved