E Evi Apr 29, 2008 #2 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
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
D Dennis Apr 29, 2008 #3 In your delete query, in the criteria row of the relevant field that begins with 's', put this Like "S*"
In your delete query, in the criteria row of the relevant field that begins with 's', put this Like "S*"
