Working with text results and "set field"
OK, here's my complete situation.
We have a report that is used to show each department their pending service request. We have the status of "Pending" or "Resolved" so the report was simply using this:
Set Field [Services::Status; "Pending"]
This would get the results with no problem. Yet someone decided to add another status: "Work in Progress"
So now I'm in a pickle. Either I have to find a way to select "Pending" AND "Work in Progress" or I have to find a way to select all and exclude "Resolved".
Thoughts? I appreciate your help with this.