Sql String 2 Inner Join (1 Viewer)

fdesu · Aug 9, 2019

Hi there,
I'm working in sql string, but i can't make it work, but in MS Access report work fine.

I have this problem only in VBA when im using 2 Inner Join,but with 1 no problem.

Set rs = CurrentDb.OpenRecordset ("SELECT * FROM despachos INNER JOIN clientes ON despachos.id_cliente = clientes.id_cliente INNER JOIN localidad ON despachos.id_localidad = localidad.id_localidad")

VBA Error: Error Syntax.

What am i missing?

Thanks

Regards!

June7 · Aug 9, 2019

Build the query in Access and then use SQLView to see structure. I think need a pair of parens around join clause. Access will provide them.

fdesu · Aug 9, 2019

June7 said:
Build the query in Access and then use SQLView to see structure. I think need a pair of parens around join clause. Access will provide them.

Hi June7,
Thanks for you help.

This is with SQLView, I try with it too, but i have the same result.

SELECT *
FROM (despachos INNER JOIN clientes ON despachos.id_cliente = clientes.id_cliente) INNER JOIN localidad ON despachos.id_localidad = localidad.id_localidad;

theDBguy · Aug 9, 2019

fdesu said:
Hi June7,
Thanks for you help.

This is with SQLView, I try with it too, but i have the same result.

Hi. If you copied and pasted the query's SQL view into your code, can we please see exactly how you did it? What does the final code look like now?

fdesu · Aug 9, 2019

Is working now, it's a bit embarrassing it must have been a comma or a dot.

Thanks for the time!

theDBguy · Aug 9, 2019

fdesu said:
Is working now, it's a bit embarrassing it must have been a comma or a dot.

Thanks for the time!

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

Sql String 2 Inner Join (1 Viewer)

fdesu

New member

June7

AWF VIP

fdesu

New member

theDBguy

I’m here to help

fdesu

New member

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread