Delete QRY

  • Thread starter Thread starter Dubai1
  • Start date Start date
D

Dubai1

I have imported a text file to a access and in several columns i have lines
due to the downloading from another software. This is what i have in each
fiels of row/column ----- and in one raw i have letters not related to what i
have downloaded and i need to delete that one as wel.
What rule i need to put to delete the two above?
 
To delete the record with dashes in a specific field.

DELETE
FROM SomeTable
WHERE SomeField = "-----"

You can expand the where clause to test many fields if there is the
possibility of a field in a valid record that consists of "-----".

You will have to explain in a bit more detail about your second type of
row. How can you distinguish the value(s) in this row from the values
in the rows you want to retain?
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top