Rewrite in access

[Newbi1]

Somehow my Db is being a pain, I cannot seem to link my sql Server view to access. Keeps giving me an ODBC error when trying to run it.

I need to rewrite this query in access. Any help is appreciated.

SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT, Employee_1.EMPSNAME AS Pic, dbo.Employee.EMPSNAME AS PM,
dbo.Project.PROLNAME
FROM dbo.Project LEFT OUTER JOIN
dbo.Employee ON RIGHT(dbo.Project.PROPRIN, LEN(LTRIM(RTRIM(dbo.Project.PROPRIN))) - 1) = dbo.Employee.EMPIDNO LEFT OUTER JOIN
dbo.Employee Employee_1 ON RIGHT(dbo.Project.PROPM, LEN(LTRIM(RTRIM(dbo.Project.PROPM))) - 1) = Employee_1.EMPIDNO

 

[JayKusch]

You need to post the question in the Access forum then. This is the SQL Server forum.

Thanks

J. Kusch