-
When I run my vb app I get the following error message:
Run Time error ‘3075’
Syntax error (missing operator) in query expression ‘Date1>=#01/01/2999# AND Date2<=#01/31/2000# And City = ‘NY# AND State = ‘New York’
Here is my SQL query:
It takes a snap shot of what is in the db and places it into a temp db the variable is strtempDB
db.Execute "SELECT * INTO Places IN '" & strTempDb & "' FROM Places WHERE Date1>=#" & Format(datFromDate, "mm/dd/yyyy") & "# AND Date2<=#" & Format(datToDate, "mm/dd/yyyy") & "# AND City = '" & (datCity.Text) & "# AND State = '" & (datState.Text) & "'"
Can someone please correct the errr I am encountering:
The problem is either the ' " or the #
Help is appreciated,
Stevie
-
You're right...
the missing sign is ' after the city= 'NY' you left out the second '
hope it helps...
Code:
db.Execute "SELECT * INTO Places IN '" & strTempDb & "' FROM Places WHERE Date1>=#" & Format(datFromDate, "mm/dd/yyyy") & "# AND Date2<=#" & Format(datToDate, "mm/dd/yyyy") & "# AND City = '" & (datCity.Text) & "' AND State = '" & (datState.Text) & "'"
Saludos...;)
-
Here is the correction I made:
db.Execute "SELECT * INTO Places IN '" & strTempDb & "' FROM Places WHERE Date1>=#" & Format(datFromDate, "mm/dd/yyyy") & "# AND Date2<=#" & Format(datToDate, "mm/dd/yyyy") & "# AND City = '" & (datCity.Text) & "' AND State = '" & (datState.Text) & "'"
Here is what you wrote as the correction:
the missing sign is ' after the city= 'NY' you left out the second '
db.Execute "SELECT * INTO Places IN '" & strTempDb & "' FROM Places WHERE Date1>=#" & Format(datFromDate, "mm/dd/yyyy") & "# AND Date2<=#" & Format(datToDate, "mm/dd/yyyy") & "# AND City = '" & (datCity.Text) & "' AND State = '" & (datState.Text) & "'"
Gives me the same err
Steve
