Example is missing the table HRP Data and missing a lot of the fields you're using in your original query. There are also field names that are not spelled the same in the query as they appear on the table (primarily using _ as a space in the query where there is only a space on the table.
Again hard to tell what's going wrong because even though I put in your fields that are incorrectly typed or missing on your tables I have nothing in them for comparison, I assume supervisor is coming from your Humanic_CPO_Emp_All table and I'm also assuming that the table driving your query is your Humanic_ejobsal and you are trying to find related information in the other tables that relates to this table? If so you will likely have to use right join/left join statements like this
Code:
SELECT HUMANIC_EJOBSAL.ENUMBER, HUMANIC_EJOBSAL.FIRSTNAME, HUMANIC_EJOBSAL.LASTNAME, HUMANIC_EJOBSAL.PROMOSTAT, HUMANIC_CPO_EMP_ALL.GRADE, HUMANIC_EMPTRAIN_MASTER.STATUS_DATE, HUMANIC_TRAINING_COURSE.[COURSE NO], HUMANIC_TRAINING_COURSE.[COURSE NAME], [HRP DATA].HRP, HUMANIC_CPO_EMP_ALL.[JOB TITLE], HUMANIC_CPO_EMP_ALL.DIV_1_DESC
FROM [HRP DATA] RIGHT JOIN ((HUMANIC_EJOBSAL LEFT JOIN HUMANIC_CPO_EMP_ALL ON HUMANIC_EJOBSAL.SSN = HUMANIC_CPO_EMP_ALL.SSN) LEFT JOIN (HUMANIC_TRAINING_COURSE RIGHT JOIN HUMANIC_EMPTRAIN_MASTER ON HUMANIC_TRAINING_COURSE.[COURSE NO] = HUMANIC_EMPTRAIN_MASTER.[COURSE NO]) ON HUMANIC_EJOBSAL.SSN = HUMANIC_EMPTRAIN_MASTER.SSN) ON [HRP DATA].SUPERVISOR = HUMANIC_EJOBSAL.SUPERVISOR
WHERE (((HUMANIC_EJOBSAL.PROMOSTAT) In ('EMT','D10')) AND ((HUMANIC_TRAINING_COURSE.[COURSE NO]) In ('LD518','LD519','LD520','LD521'))) OR (((HUMANIC_EJOBSAL.PROMOSTAT) In ('EMT','D10')) AND ((HUMANIC_TRAINING_COURSE.[COURSE NO]) Is Null));