Ms-access – How to delete the blank rows

ms-access

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.

Best Answer

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

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

Related Solutions

Sql – How to get a value from previous result row of a SELECT statement

This sql should perform better then the one you have above, although these type of queries tend to be a little performance intensive... so anything you can put in them to limit the size of the dataset you are looking at will help tremendously. For example if you are looking at a specific date range, put that in.

SELECT followup.value, 
    ( SELECT TOP 1 f1.VALUE 
      FROM followup as f1 
      WHERE f1.id<followup.id 
      ORDER BY f1.id DESC
    ) AS Prev_Value
FROM followup

HTH

Ms-access – How to order the null values

  SELECT * FROM  
 (SELECT *, IIF(Val(Value) > 0, 2, IIF(ISNULL(Value), 3, 1)) AS MyOrder FROM MyTable)  
Order by MyOrder

EDIT: I think this one is clear. Modified as per Robert's query ;)

SELECT * FROM MyTable
ORDER BY IIF(Val(Value) > 0, 2, IIF(ISNULL(Value), 3, 1))

Best Answer

Related Solutions

Sql – How to get a value from previous result row of a SELECT statement

Ms-access – How to order the null values

Related Topic