Hi,
I wish to add additional variables to the following peice of search code:

<code>

Dim Var1

Var1 = ("P"

Dim nameRS
Set RS1 = Conn.Execute("Select NAME FROM TABLE1 WHERE TABLE1.REF = '" & (Var1) & "' "

</code>

This works fine, but I wish to add another variable, such as:

<code2>

Dim Var1, Var2
Var1 = ("P"
Var2 = ("Q"

Dim nameRS
Set RS1 = Conn.Execute("Select NAME FROM TABLE1 WHERE TABLE1.REF = '" & (Var1) & "' OR '" & (Var2) & "' "

</code2>

This doesn't include the additional Var2 in the search results and causes 'odd' search results. Is this syntax. Just to recap, code example 1 works but I just need to add an additional variable and include it in the search parameters.

Thanks in advance.

Set RS1 = Conn.Execute("Select NAME FROM TABLE1 WHERE TABLE1.REF = '" & (Var1) & "' OR TABLE1.REF = '" & (Var2) & "' "

Thnaks very much, that works a treat.