I need to be able to query a database based on three different fields. Two text fields and one date/time field.
The query returns records when i leave out the date but when added no records are returned.
The following code works correctly. But now i need to check if the field "updated" value is >= sDate and <= eDate
Thanks In Advance
'Get start and end dates from to dateTimePickers
sDate = dateStart.Value.Date
eDate = dateEnd.Value.Date
sql = "select * from mainTable where repNumber=" & _
repNum & " And Stage ='" & cboStage.SelectedItem & "'"
da = New OleDb.OleDbDataAdapter(sql, con)