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*"
 
Back
Top