if 0 show " ", 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 &lt;500 I want it to show as "B", 
if the value is >500 I want it to show as "R"
Try:

IIf([value] = 0, "", IIf([value] &lt; 500, "B", "R"))


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