0

Hi, I have a simple query I've used again and again previously, but in this case it's telling me that it is too complex. I've output this sql string into a message and cannot see any problems with the syntax, I'm completely baffled with this one so any help would be greatly appreciated.

SQL = "SELECT * FROM thisQuery IN '" & path & "' WHERE thisQuery.[Score]" & operator & Score

Forms(stDocName).RecordSource = SQL

operator is a variable taken from the form's combo box of =, >, <, etc. and score is a variable taken from the other combobox of 1-5.

2
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by StephNicolaou
0

The score is actually a string so teh problem lays when using the operator...Any ways around this?

0

Have you tried ommitting the IN? Or if Score is a string, then make it operator & "' & Score & "'"

Edited by scudzilla: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.