I have a table with Column "DateIn" and "DateOut". I want to use a Sql statement to filter out all Rows which DateOut is Empty.
So..i Use a statement

Try
OutSearchIDAdapter1.SelectCommand.CommandText = _
"SELECT PaperRollID FROM PaperRollTransaction WHERE " & _
"DateOut = '""' " & _
"ORDER BY PaperRollID ASC"
OutSearchIDAdapter1.Fill(OutSearchIDDataSet11)

Catch oledbdataexception As System.Data.OleDb.OleDbException
MessageBox.Show(oledbdataexception.Message)
End Try

The above statement is giving me an error message. I know that my Sql statement has error in WHERE clause. So..just wonder how do i filter out the Empty Column in Access Table.