Change this query to Access

[Newbi1]

I need to convert this query from SQL Server to Access. Any help would be appreciated.

Thanks in advance


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

 

[fredericofonseca]

Newbi1,

Please don't cross post unless asked to do so by other members.

I have replied to this question on thread68-1073650

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com