Hello all,
I'm working on a report that groups based on ID. My question is, how can I hide specific IDs from showing up based on a text string from another field? Any way I try to filter this, it only gets rid of the row with the specified text string, not the entire ID from the list.
You can use the Except object from the query explorer's toolbox to achieve what you need. You would need one query that returns IDs where your string matches, one query that returns all IDs. Except those from each other and then join up the result to your original data query again.