if 0 show " ", if <500 show "B", if >500 show "R"

I'm working on a query in Access 2010 and need help.

• If the value is =0 I want it to show as blank,

• if the value is

• if the value is >500 I want it to show as "R"

Try:

IIf([value] = 0, "", IIf([value] < 500, "B", "R"))

IIf is a function that returns on of two values depending on the outcome of the conditional.

StackExchange Database Administrators Q#124276, answer score: 7