Actually, what I'm trying to do is fix this syntax error:
"syntax error(missing operator) in query expression'qryRGAqtr![Date] = 2Q 2000'."
my SQL statement:
sqlstate = "SELECT qryRGAqtr![Date],qryRGAqtr![Apple],qryRGAqtr![Other],"
sqlstate = sqlstate & "qryRGAqtr![Apple %],qryRGAqtr![Other %] FROM qryRGAqtr"
sqlstate = sqlstate & " WHERE qryRGAqtr![Date] = " + startdate + " ;"
I have a field in my query called "Date". The query is based on a table and "Date" has date/time data type but I had to convert the "Date" to a different date format, I think by doing to I have changed the "Date" date/time data type to text and stored that into the query. Is that correct?
If so, I would need to find out the "Date" date type in the query so it will match to the the variable which contains the value of a textbox in my SQL statement.