Two related fields on the same table but several tables missing both related fields

Hello!   I'm experiencing this issue when arriving at the totals for my report. I currently have several tables that are connected by the same related field (many-to-many) called Employee ID. Howev...