if {your department field} = "WD"

then "Welding Department"

else

if {your department field} = "HR"

then "Human Resources"

else

so on and so on...

 

Now, the bad part about it is that you would have to have an if, then, else statement for each department.  If you do decide to go this route, then simply add it to your report where you would have put the other field that is just showing "WD".  Depending on the order that you want it sorted, you could sort either on the department field in your table, or the formula field that you have just created.  Hope this helps!!  Good luck!

 

Take care!

 

 

You can add this to the last line of your code too  "and" (without quotes) and the following line would be {department}<>WD

Hope that helped.

 

Andy