Hi:
Can someone please tell me what is I am doing wrong with this statement. The statement is returning 0 and I know there are at least 100 records in my table.


I think the problem is with the date. I am not be converting the date to its proper datatype.

lcsql = "Select * from TaxName Where Meeting_ID= " & _
Chr(39) & Trim(Str(iMeeting_ID)) & Chr(39) & _
" And Event_Date =" & "02/02/2004"


oRecData.Open lcsql, oDataConn
x= oRecData.RecordCount