delete query help

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

Guest

I want to delete all records in a table with a field called MoldID with < 5
characters. Is this possible?
 
Use a delete query:

1. Create a query into this table.

2. Change it to a Delete query (Delete on Query menu.)
Access adds a Delete row to the query grid.

3. Drag the asterisk from the table in the top half of the query window into
the grid.
Access indicates it will delete from the table.

4. In the next column of the query grid, Field row, enter:
Len([MoldId])
In the Criteria row under this, enter:
< 5
If you intended to delete the records where there is nothing there at all,
set the Criteria to:
Is Null Or < 5

5. Run the query.
 
Back
Top