Word code

[Sergio]

I have the above code to insert an access quey in a word document, but the IdCliente filter doesn´t work. I nedd too SELECT only few fields from the query GarantCont'

 

[CJ_London]

What happens if you remove the where clause? The sql structure doesn’t look right to me but perhaps it is valid when constructed in word?

 

[The_Doc_Man]

I suspect that the quoting is wrong in the SQL because the WHERE clause appears to be outside of the SELECT.

 

[Sergio]

What happens if you remove the where clause? The sql structure doesn’t look right to me but perhaps it is valid when constructed in word?

If I remove or not "where" clause the table appears with all the registers

 

[Gasman]

Have you tried standard concatenation and just the required fields instead of * ?

 

[Sergio]

I suspect that the quoting is wrong in the SQL because the WHERE clause appears to be outside of the SELECT.

I found the right code, tks

 

[Gasman]

So good, it had to be posted three times?