delete rows containing blank/missing values

  • Follow


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.

0
Reply prasanna 3/11/2007 5:47:50 AM

The normal technique would be to construct a SELECT query that returns
only the rows you want.

What distinguishes these rows from the others?

On 10 Mar 2007 21:47:50 -0800, prasanna.kusam@gmail.com wrote:

>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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.
0
Reply John 3/11/2007 6:59:56 AM


1 Replies
664 Views

(page loaded in 0.044 seconds)

Similiar Articles:
















7/23/2012 12:40:16 AM


Reply: