S
SHIPP
I create a variable in vb code. If I debug and print it it looks like so...
"'HOLD' or 'HARD HOLD' or 'AUTOHD'"
The code for creating it is sending it through a loop...
strSQL = Chr(39) & varRet & Chr(39) & " or "
and then
strSQL = Chr(34) & Mid(strSQL, 1, Len(strSQL) - 4) & Chr(34)
It does not come up with any results. However when I manually put in
"HOLD" or "HARD HOLD" or "AUTOHD"
the query runs. What am I doing wrong?
"'HOLD' or 'HARD HOLD' or 'AUTOHD'"
The code for creating it is sending it through a loop...
strSQL = Chr(39) & varRet & Chr(39) & " or "
and then
strSQL = Chr(34) & Mid(strSQL, 1, Len(strSQL) - 4) & Chr(34)
It does not come up with any results. However when I manually put in
"HOLD" or "HARD HOLD" or "AUTOHD"
the query runs. What am I doing wrong?