如何删除空白行? [英] How to delete the blank rows?

问题描述

使用Access 2003

Using Access 2003

表1

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

预期产量

ID名称值

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

...，

需要查询帮助.

推荐答案

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

或

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

这篇关于如何删除空白行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！