Currently having an issue while using string variable TSx=arrayREP(0, i) for WHERE criteria statement in SELECT FROM WHERE string SQL query.
TSx = ("criteriax") because Dim variable As String and I need [(criteriax)-returned value from array not wrapped in " "] for query to act properly.
Dim TSx As String
Dim QRYx As String
TSx = arrayREP(0, i)
QRYx = "SELECT tbl.field1, tbl.field2, tbl.field3, tbl.field4, tbl.field5, tbl.field6, tbl.field7,FROM tbl WHERE tbl.field1=TSx"
Box asking for parameters for TSx appears after running. If I enter the value for TSx without the " " wrapped around it from using string variable everything else works perfectly.
I've been self-teaching over the past two days and so far this is only trouble I'm having, probably because its within a For Next Loop. Hopefully just a minor fix/conversion.