Conditional Detail Filter

[damienm]

Dear All,
Currently I have detail filtered a report based only on a field in the report OCD > 30, what I need to do now is apply some criteria to this and unsure of the formula.

Report format is as follows

Brand-------------OCD Days------------Inventory
X                          35                          15000
B                         105                          5000

I want to filter and show only based on brand and OCD Days, basically for brand X OCD days > 90 and brand B >30 OCD days. How would I go about this, I am thinking IF statements but no idea how to write it, IF brand = X and OCD days > 90, otherwise >30...........??????????????

Any help would be gratefully appreciated!

[billylodz]

(brand=x and days>90) or (brand<>x and days>30)

[damienm]

So how would you construct this, in a detail filter on brand or days OCD, sorry I am new to this and just finding my feet!

Thanks for your help!