delete query

[Guest]

How can I create a query to delete all records in an Item table that begin
with the letter "s"?

 

[John Spencer]

DELETE DISTINCTROW ItemTable.*
FROM ItemTable
WHERE ItemName Like "S*"

If you are using the query grid
Field: ItemName
Table: ItemTable
Criteria: Like "S*"

Select Query: Delete from the menu


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..