This works, but I want to change the ( p.Department) to a parameter as well.
Please Login or Register  to view this content.
Like this:
Please Login or Register  to view this content.
So if I put p.Department in the cell the parameter looks to, it doesn't work. The query just turns up nothing.
Shouldn't I be able to have a parameter be a table column name? I couldn't find any examples of anyone trying to do this.
Thanks for the help!