sqlStr1 = "SELECT * FROM sold WHERE dateOfSold=" & "3/29/2007"
I used this statement to retrive all the data they have value 3/29/2007 in the field of dateOfSold. When i try this statement this return empty record set. dateOfSold field is in access table sales. fieldtype is date/time. plese help me