I have a table field where I want to show requests that have to be signed off by the login user. There is a 4x7 possibility - 7 groups and one of 4 approvers can approve. So, here's my qualification. This works except the table field is showing all Statuses. I just want to show Proposed. ARS keeps adding the extra ) at the end. I've tried removing some parens but it still keeps putting it back or I get an error if I remove the leading and trailing parens... Anyone see anything obvious?
(( 'Approve2' = $NULL$ ) AND (( 'Approver 2' = $USER$) OR ( 'Approver 9' = $USER$) OR ( 'Approver 16' = $USER$) OR ( 'Approver 23' = $USER$))) OR (( 'Approve' = $NULL$ ) AND (( 'Approver 1' = $USER$) OR ( 'Approver 8' = $USER$) OR ( 'Approver 15' = $USER$) OR ( 'Approver 22' = $USER$))) OR (( 'Approve3' = $NULL$ ) AND (( 'Approver 3' = $USER$) OR ( 'Approver 10' = $USER$) OR ( 'Approver 17' = $USER$) OR ( 'Approver 24' = $USER$))) OR (( 'Approve4' = $NULL$ ) AND (( 'Approver 4' = $USER$) OR ( 'Approver 11' = $USER$) OR ( 'Approver 18' = $USER$) OR ( 'Approver 25' = $USER$))) OR (( 'Approve5' = $NULL$ ) AND (( 'Approver 5' = $USER$) OR ( 'Approver 12' = $USER$) OR ( 'Approver 19' = $USER$) OR ( 'Approver 26' = $USER$))) OR (( 'Approve6' = $NULL$ ) AND (( 'Approver 6' = $USER$) OR ( 'Approver 13' = $USER$) OR ( 'Approver 20' = $USER$) OR ( 'Approver 27' = $USER$)) OR (( 'Approve7' = $NULL$ ) AND (( 'Approver 7' = $USER$) OR ( 'Approver 14' = $USER$) OR ( 'Approver 21' = $USER$) OR ( 'Approver 28' = $USER$)) AND ( 'Status' = "Proposed")) Thanks! Dave _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
