delete record

  • Thread starter Thread starter r brooks
  • Start date Start date
Before running this sort of query, always make a copy of your database.

In the query's Design view
Add a column to your query

Initial: Left([YourFieldName],1)

Filter this column with
"s"

Click the down arrow next to the Query Type button and choose Delete query.
Press the red ! button to run the query.

Evi
 
In your delete query, in the criteria row of the relevant field that begins
with 's', put this

Like "S*"
 

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 1
Delete Query: Could not delete from specified tables 0
Finding Records starting with a letter 1
deleteing query 3
The not "Max" records 1
deleting a record 1
Using Delete Query 1
deleting related records at once 2

Back
Top