Sql Statement

[chinhow]

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.

[Athley]

Try...

"SELECT PaperRollID FROM PaperRollTransaction WHERE " & _
"DateOut Is Null " & _
"ORDER BY PaperRollID ASC"

[chinhow]

I got it!, anywhere thanks.

I have another question, Example, i have many date values inside the table; 11/23/2002, 11/24/2002, 11/25/2002, 12/12/2002, 12/14/2002, 12/25/2002. how to i just filter out records on monthly basic?

For Instance, I wan the records on Dec / 2002.

[CoMMiE]

hi maybe you could try this:
Select from tablename where date>= '"& 12/1/2002 & "'and Date <= '" & 12/31/2002 & "'"

[chinhow]

i wan to do it in a flexible way, i would have 2 text/combo box to select MONTH and YEAR, respectively.

[CoMMiE]

In that case you could try doing this

Select from tablename where date= '"& comboboxmonth.text &"/1/"& comboboxYear.text &"'"

[chinhow]

Will it filter out only 1/1, 2/1, 3/1 ... 12/1??