I am having an issue with this If Statment and was wondering if somebody could give me some advice on the best way to write this IF statement.

IF {Product.Procduct} = "Product1" AND ({Rate.Monday} < .81 OR {Rate.Tuesday}< .81 OR {Rate.Wednesday} < .81 OR {Rate.Thursday} < .81 OR {Rate.Friday} < .81 OR {Rate.Saturday} < .81 OR {Rate.Sunday} < .21) THEN TRUE

Else IF {Product.Product} = "Product2" AND ({Rate.Monday} < 1.01 OR {Rate.Tuesday}< 1.01 OR {Rate.Wednesday} < 1.01 OR {Rate.Thursday} < 1.01 OR {Rate.Friday} < 1.01 OR {Rate.Saturday} < 1.01 OR {Rate.Sunday} < 1.01 ) THEN TRUE

ELSE IF ({Rate.Monday} < 1.50 OR {Rate.Tuesday}< 1.50 OR {Rate.Wednesday} < 1.50 OR {Rate.Thursday} < 1.50 OR {Rate.Friday} < 1.50 OR {Rate.Saturday} < 1.50 OR {Rate.Sunday} < 1.50 ) THEN TRUE

Edited by alrichar - 24 Dec 2012 at 5:32am

Thank you for the response. I was initially thinking the same thing but it doesn't seem to be the issue. There is one location with a data entry error where the Tuesday Rate is 150 and the report is not picking it up since other days have a rate of .15.

The third Else IF is in there so that it captures all of the other products (These are constantly being added into our system). I took it out to see if the third Else IF was overriding the other two conditions. There are still locations that have Product1 with a Tuesday Rate (or other days) higher than the .81.

I guess this is my reasoning:

First Condition - Suppress Product1 if any Mon-Sun Rate is below .81
Second Condition - Suppress Product2 if any Mon-Sun Rate is below 1.01
Third Condition - Suppress all other products if any Mon-Sun Rate is below 1.50
Everything else Show

Thanks for the reply.  Yes, my wording is a little bit confusing.  The statment is saying that if Mon, Tues, Wed, Thurs, Fri, Sat, or Sun rate < 1.5 then suppress the data.  Therefore, the only records that are showing are the incorrect rates that are >= 1.5.

<soapbox>