If based on the outcome of 2 fields

I am trying to create an access 2007 report. This is based on a cross tab query. I use a SQL statement of the basis for my crosstab and I want a value returned to be based on the combined vakue of two fields. the IF statement that I need to represent is something like the below.

IF field1 is one of 5 values and field2 = 0 then
"orange"
Else
IF field1 is one of 2 values and field2 = 1 then
"brown"
Else
"Black"

What is the best way to do this?

Thanks