I'm really new with access and web design. I'm trying to create a dynamic
query page to query our helpdesk database. There is a drop down box that
allows the user to specify using a 'AND' or 'OR' statement in the SQL query.
But I can't get it to work. It is some kind of syntax error that I can't
figure out. Here is my Where clause:
WHERE "%%field1%%" = '%%string1%%' '%%operator%%' "%%field2%%" =
And I get this error message:
Database Error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression '[PROBTYPE] = 'pc' 'AND' [TECHID] =
If I litteraly use "AND" (with no quotes) instead of '%%operator%%' it
works, so I'm thinking its something wrong with the quotes or something.
Any help would be greatly appreciated. Thanks!