delete query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create a query to delete all records in an Item table that begin
with the letter "s"?
 
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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Using Delete Query 1
Delete Query Help 2
Delete records 5
Access 2010 append query to SQL is very slow 0
Deleting duplicate records 3
append query and delet query 7
Removing Certain Records from a Query and Report 1

Back
Top