sql - DLookup on a report in Access 2013 -

i have attendance log keeps track of patient attendance in office. have many therapists see patients. therapists listed on "employees" table id called "id". on table "cancellog table", have field stores name of therapist patient supposed see called "therapist". lookup field "employees" table. our staff can select name , can add options add , remove therapists. have report pulls directly table, showing relevant fields can @ number of cancelations had. showing therapist, shows id, not name. in "employees" table have field stores "first name" , "last name".

i have report show name , not number in text box. have tried using dlookup , ended following:

= dlookup([employees]![first name], [cancellog table], "[therapist]="'& [employees]![id] &"'")

but not working. assistance helpful. thank you.