title: MS Access color query in iif condition
body: <p>I want to write a query for the requirement below:</p>
  
  <p>[FMV] is a field with numerical value. If value inside [FMV] is less than 14, display the values in the range in GREEN, if the value is greater that 28, display this range values in RED and if in between 28 and 14, AMBER. Also, all the result [FMV] field should come in one field as [FMV] itself with required colors as per condition.</p>
  
  <pre><code>SELECT IIF([FMV] &gt; '28', "RED") AND IIF([FMV] BETWEEN '28' AND '14', "AMBER") AND IIF([FMV] &lt; '14', "GREEN")
  FROM Qry_pre_FPI_IMV;
  </code></pre>