title: User is prompted for same query parameter more than once (MS-Access)
body: <p>I have a parameter query selecting information from my table based on the start date entered by the user and today's date. I want to search two fields in my table with the WHERE statement without entering the prompt for the starting date twice. Right now I have:</p>
  
  <pre><code>SELECT PatientSurvey.PatientID
  FROM PatientSurvey
  WHERE (PatientSurvey.[6MonthSurveyReturn] OR PatientSurvey.[12MonthSurveyReturn]) Between [Enter the last date checked for:] And Date();
  </code></pre>
  
  <p>This doesn't seem to work. But if I do the following:</p>
  
  <pre><code>SELECT PatientSurvey.PatientID
  FROM PatientSurvey
  WHERE (PatientSurvey.[6MonthSurveyReturn]) Between [Enter the last date checked for:] And Date() OR (PatientSurvey.[12MonthSurveyReturn]) Between [Enter the last date checked for:] And Date();
  </code></pre>
  
  <p><strong>Then it prompts the user twice for the same input.</strong> How can this be prevented?</p>