I'm using Jet 4.0 and SQL to control an MS Access DB.
I have an sql statement.
Expr1 AS ExprName1,
Expr2 AS ExprName2
WHERE Tabel1.PrimeKey = Tabel2.ForeignKey AND
Field2 BETWEEN '14/08/2001' AND '14/09/2001'
When i run it the server brings up an error "Invalid data type in condition statement". When i take out the part..
"Field2 BETWEEN '14/08/2001' AND '14/09/2001'"
.. it works fine and i have to restrict the date in the code (i'm using VB with SQL to access the data base).
does anyone know whats wrong? the code would be a lot simpler if the SQL statement could work.