delete a query where alll record descriptions start with an "L"

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

Guest

I need to delete all records in a query where all records have a description
that starts with an "L". But I don't know how to put that into the criteria
box. Please Help!
 
The criteria would be
WHERE [Tablename].[Description] LIKE "L*"

If you are using the query grid:
WHERE: Like "L*"

That will find all records where the field begins with L or l and has zero to
many characters afterwards. If you are not using an mdb file (standard Access
database) you may need to use
Like "L%"
as the criteria
 
Back
Top