Help needed constructing an expression

[shteev]

I'm trying to write an expression in a Query.

I have a column of numbers, values between 1 and 10 (may be fractional). I want to construct an expression in an adjacent column that will print '+' is the value is >=9,
'-'if the value is <=2, and NULL in any other case.

Currently I'm using this expression, to just print a single character is the value is high OR low:

IIf([value]<=2 Or [value]>=9,'*',Null)

 

[mndrlion]

IIF([value] <= 2, '-', IIF([value] >= 9, '+', Null))

 

[shteev]

Cheers.