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.
VBA Error: Error Syntax.
What am i missing?
Thanks
Regards!
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!