Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

Access Query Examples
MS Access SQL Support & Training
Access Delete Query Example

SQL Delete Query Tutorial Queries Microsoft Access 2007 Query Help
Professional Microsoft Access Programmers

Access Template Databases:


MS Query Tutorials:

Aggregate Functions
Choose Function
More Choose Functions
Crosstab Query Tutorial
Crosstab Query Advanced
DateTime Query
Delete Query Tutorial
External Link Query
Access Report Filter Query
Group By Clause
Access Having Clause
Histogram Query Tutorial
Insert Into Query
Master/Detail Updates
Order By Dynamic
Access Parameter Query
Predicate Query Example
Self Join Query Tutorial
Scalar Query Example
Child/Parent Table Query
Select Statement Tutorial
Select Top 1 Query
Union Query Example
Access Update Query

Multi-Select Parameter Forms Query Tutorial


Delete Query Tutorial

The Delete query in MS Access is a DML (data manipulation language) command used to remove one or more rows of data from a relational database table.  The number of rows deleted is dependent upon the existence and criteria within the where clause of the delete query.

The basic syntax of the Access Delete query is:

Delete TableName.* From TableName Where somecriteria;

Note that using an Access delete query without the where clause will delete all rows from the specified table.

The asterisk in TableName.* is a wildcard character and refers to all fields within the table.  You may only delete entire records rather than values in particular fields therefore the asterisk is mandatory.

If TableName is a table which is defined as the master of a master-detail relationship and the cascade delete property of the relationship is set to true then corresponding records in the detail table will also be deleted.

The delete method is often preferable to the drop table method, which complete removes the table from the database, because all of the characteristics of the table remain intact - such as the indexes, relationships and primary keys.

Now with real column and table names:

Delete *  From M_Employees Where  Emp_Name = "Joe";

The above query will delete all employees with an employee name of Joe.

More Access Delete Query Examples:

Docmd RunSQL Access Database Example

Examples are Update, Delete, Insert Into, etc., queries. ... RunSQL "Delete * from t_orders" ' 'create and run the append queries ...


Visual Basic Select Case in Access

RunSQL "delete * from mailmerge in '" & pitney & "'" sqltext = "INSERT INTO mailmerge (name,address1,address2,city,state,zip) in '" & pitney & "'" & _ ...


Concatenate Records Text Field

RunSQL ("delete * from t_patient_alrgy") ' start creating new list ' select list of records for this patient Set rst = db.OpenRecordset("SELECT Allergy "


Contact Information

Microsoft Access Developer

Microsoft Access Query 2007 2003 2000 Access Query Tutorial