title: Microsoft Access query based on option button
body: <p>I am building a query in Access. One of the fields [V2] needs to be filtered if an option button on the [Main] form is selected. Right now, I have the following criteria entered for the field.</p>
  
  <pre><code>Field:         Expr3: [V2]&gt;0
  On Criteria:   IIf([FORMS]![Main]![optV2]&lt;0,True)
  </code></pre>
  
  <p>In the event that the option button is selected, the data is sorted properly. However, in the event that [FORMS]![Main]![optV2] is not &lt;0 (meaning the option button is not selected), I would like all data regardless of [V2] value to be displayed. Currently, no data is displayed if the button is not selected.</p>
  
  <p>Any suggestions on how to do this?
  Any help is appreciated!
  Thanks, </p>
  
  <p>Lucas</p>