I have a report that is controlled by a query with a field name "employee on job" with the following criteria
like "*" & [Select Option] & "*"
which works great but I would like what ever selected option is selected will show in the report header.
I have tried creating a unbound text box in the header and adding the follow =[report]![payroll] like "*" & [Select Option] & "*"
there is no error but it shows a number and not the text.
thanks Angie