My report is run from the main form: The user selects a branch and clicks a button that runs the report for the branch that was selected.
The report contains employee cost information and the employee's role.
In the header section of the report I created a text box with the following Expression: =IIf([Role]="Division Manager",[EmployeeName],"")
--- If the field in the detail named Role contains "Division Manager" then display the employee name in the text box, else display nothing.
For some reason it only works for some of the branches!
There are 6 branches that have employees with the role "Division Manager" but only 2 show up in the text box.
For example:
In the main form, when I select branch 120 and click to run the report, I get the results I want in the detail (including an employee with the role "Division Manager" but the division manager doesn't populate in the header.
Yet, in the main form, when I select branch 910 and click to run the report, I get the results I want in the detail and the division manager in the header!
When I look at the query results that the report is based on, all the information I need is there.. I can't figure out why some fill the text box and some don't Ugh!
I hope it's something silly I've missed.
Thank you for your help
Frustrated Lynda
The report contains employee cost information and the employee's role.
In the header section of the report I created a text box with the following Expression: =IIf([Role]="Division Manager",[EmployeeName],"")
--- If the field in the detail named Role contains "Division Manager" then display the employee name in the text box, else display nothing.
For some reason it only works for some of the branches!
There are 6 branches that have employees with the role "Division Manager" but only 2 show up in the text box.
For example:
In the main form, when I select branch 120 and click to run the report, I get the results I want in the detail (including an employee with the role "Division Manager" but the division manager doesn't populate in the header.
Yet, in the main form, when I select branch 910 and click to run the report, I get the results I want in the detail and the division manager in the header!
When I look at the query results that the report is based on, all the information I need is there.. I can't figure out why some fill the text box and some don't Ugh!
I hope it's something silly I've missed.
Thank you for your help
Frustrated Lynda