delete rows containing blank/missing values

  • Thread starter Thread starter prasanna.kusam
  • Start date Start date
P

prasanna.kusam

I have very large database( almost 500,000 ) that contains road
characteristic readings in two columns taken by a highly sophisticated
instrument . I would like to remove the rows that the instrument
missed to take the reading. Could some one help me in doing this.
 
Hi -
Make sure you backup your application before trying this.
Copy/paste the following to a new query, substituting your
table & field names:

DELETE
MyTable.*
FROM
MyTable
WHERE
(((MyTable.Field1) Is Null))
OR
(((MyTable.Field1) Is Null));

HTH - Bob
 
Back
Top