看看这里: http://www.foxtable.com/help/topics/0696.htm
很简答的: Dim cmd As New SQLCommandDim Count As Integercmd.CommandText = "DELETE FROM {表A} WHERE 门诊号 Is Null"Count= cmd.ExecuteNonQuery()DataTables("表A").Load()