This is correct assuming the [emd_id] is numeric:
TrainerName: DLookUp("[Name]","Active Employee Query","[trn_emp2class].[trainer]=" & [emp_id])
If it's a string, this is correct:
TrainerName: DLookUp("[Name]","Active Employee...