ms-access

How to delete the blank rows?

Using Access 2003

Table1

ID Name  Value

001 Raja 100
002 Ramu 200


004 Raqu 500



008 Ravi 250

...

Here I want to delete the blank rows in my table? 

Delete from table1 ...?

Expected Output

ID Name Value

001 Raja 100
002 Ramu 200
004 Raqu 500
008 Ravi 250

...,

Need Query Help.

Solution 
  • Delete from table1 
where ID=' '
and Name=' '
and Value=' '

    or 

    Delete from table1 
where ID is null
and Name is null
and Value is null