Need help with a WHEN function

[keating101]

Hello All

I have a report which i want to filter data by two transaction types, lets say "apples" and "oranges". i have done this part.

i then need to put another line of code in to say, when transaction type = apple, then only filter for colour = "green apples"

this is the code i have come up with, but i cant get it to work:
case
when[Trans Type Code] = 'APPLE'
THEN [Colour]=('Green')

Any body know a solution?

thanks in advance

Shaun

[Ammus1234]

Try this filter.
([Trans Type Code] = 'APPLE' and [Colour]=('Green')) or ([Trans Type Code] = 'orange'
and [Colour]=('Orange'))

[keating101]

Thankyou mate that worked!