I have couple of columns I want to filter on **1)**Request Type and **2)**Status
Request Type has 7 possible options of which I only want to return values when: A) [Request type] = "Ing Variance" or "Ing Substitution" or "SLE - Ing" .... after I get these results I want to filter further using the [Status] field/column... B) [Status] = 'Declined' or [Status] = 'Complete'
In the end I want to show all records who have any of the three request types which have a status of declined or complete.
I'm finding this difficult to accomplish. Can you help?
Any help would be appreciated.