I'm trying to calculate a managers commission and i'm trying to bring forward their commission percentage from their record after searching all employees for the constraints of their title = Branch Manager and their office = office listed in the current form. The office is listed in a combo box that automatically references the proper office depending on the employee selected (not the manager whose % i'm trying to bring out of the table). This is what i have but i haven't had any luck with it.
=IIF([Employee Data]!Office=""&[Office].Column(1) AND [Employee Data]!Title=”Branch Manager”, [Employee Data]![Commission %] )
=IIF([Employee Data]!Office=""&[Office].Column(1) AND [Employee Data]!Title=”Branch Manager”, [Employee Data]![Commission %] )
