Hi,

I'm getting out of suggestions now
If you copy your sql statement from your server into your code, you should get the same result... I see that in your first post you use 
t2.[Product UBR Code] in
and in your sql-server

t2.[Product UBR Code] =
This is a difference of course.



A last thing to check perhaps your selection-variable contains 'P_6664'
If this is the case => ok

But if your variable contains P_6664
in this case you have to write your sql-part like this
"... t2.[Product UBR Code] = '" & selection & "'"
Hope this helps.