put a WHERE clause on the delete statement. A WHERE clause acts as a filter.
it can be used on SELECT and DELETE statements
SELECT My, Column, List from MyTable
WHERE ANumericValue = 99
AND AStringValue = 'Blah'
AND ADateValue = '#08/21/2012#'
that would retrieve any records whose column values matches all 3 specificedvalues
the exact same WHERE clasue be used in a delete statement
Microsoft Access Delete Query, SQL Syntax, Examples and Errors
WHERE criteria don't need to be =
but they do need to resolve to a boolean value, the underpinning of a where clause
a where clause could contain OR
WHERE ANumericColumn = 96 or ANumeric Column = 52
..ie if the value in ANumericColumn id either 96 or 52, process the row, obviously you couldn't use an AND in this instance as ANumericColumn couldn't be equal to both values
WHERE ANumericColumn < 100
..ie if the value in ANumericColumn is less than 100, process the row
WHERE ANumericColumn >= 0
..ie if the value in ANumericColumn id greater than or equal to 0, process the row
WHERE ANumericColumn <> 0
..ie if the value in ANumericColumn is not equal to 0, process the row
WHERE AStringColumn LIKE "Rubber*"
if the value of AStringColumn matches the 'Rubber' (ie match the first 6 characters)
and so on...
I'd rather be riding on the Tiger 800 or the Norton