Try adding an extra set of parens after 'Status' = "Proposed" AND (... all the other stuff ...) You want to make sure the status is evaluated completely separately from the other pieces of the statement. Without this extra set of parens the Status phrase will be evalueated with your first approver# phrase, and the rest of them will be evaluated independently. The AND takes precedence over the OR operator here so you need the extra parens to override that and group all your approver# phrases togeather. -- Chris Danaceau AttivaSoft Solutions Architect
________________________________ From: Action Request System discussion list(ARSList) on behalf of Boylan, David Sent: Fri 1/8/2010 3:58 PM To: [email protected] Subject: Re: Table Qualification ** Hi Mark, Strangely enough, I tried that and I get a qualification line error at position (1070). This would be the final paren. I even tried copy and pasting your text and still get the same error. ARS insists on removing the ) at the end and putting one at the front. I'm still scratching my head on this one! Dave _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
