title: Access Query If/or condition
body: <p>I'm trying to write an OR statement in the query design in Access and its not working!
  The statementis below:</p>
  
  <p><code>Duration:If([Status2]="Q","2.5 Hours",IIf([Status2]=WS,"4 Hours", IIf([Status2]=MG,"3 Hours 15 Mins",IIf([Status2]=ID,"3.5 Hours"))))</code></p>