we are executing the following sql statement succesfully in MS Access
SELECT DISTINCT LS_ATTO.ATTODescription AS UserName, LS_ATTO.ATTOID AS UserId,
IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor
FROM LS_ATTO LEFT JOIN Passwd ON LS_ATTO.UserID = Passwd.UserID
WHERE...