I'm trying to Select Data from an Access DB.
I wrote this query to Select all Invoices that were Invoiced between two dates.
I get the following error
Syntax error (missing operator) in query expression 'Invoiced >=02/01/13 AND <= 05/01/13'
"SELECT * FROM invoiced_filter WHERE Invoiced > " & fromdte & " AND < " & todte
Dim datefrom, dateto As Date
datefrom = Convert.ToDateTime(Trim(TextBox1.Text))
dateto = Convert.ToDateTime(Trim(TextBox1.Text))
Dim cmdload As New SqlCommand(("SELECT * FROM invoiced_filter WHERE invoiced BETWEEN '" & _
datefrom.Date & "' AND '" & _
dateto.Date & "'"), con.con)
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...