title: Access SQL Query using BETWEEN Statement and dates from a form
body: <p>I'm probably missing something basic here, but I can't for the life of me get this working.</p>
  
  <p>I have a database that is tracking when certain projects are completed, and I want to be able to show in a list the completed projects between a date range.
  The date range to check between is set by the user on a form.</p>
  
  <p>I have built a query in Access:</p>
  
  <blockquote>
    <p>SELECT Logs.Completed <br>
    FROM Logs <br>
    WHERE Logs.Completed BETWEEN Forms!UIBrowseCompleted!Text53 AND Forms!UIBrowseCompleted!Text55 <br>
    ORDER BY Logs.Completed;</p>
  </blockquote>
  
  <p>I have got the dates formatted in the text box so they are in <em>#MM/DD/YYYY#</em> format (I have manually put these dates direct in the query and this works) but when I run the query I get the following error:</p>
  
  <blockquote>
    <p>This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.</p>
  </blockquote>
  
  <p>I have tried modifying the query to take the <em>#</em> out of the text fields in the form, and including <em>'</em> around the Forms!UIBrowseCompleted!Text53 but I've still not got any joy from it.</p>
  
  <p>has anyone had this issue before, or can anyone point me in the right direction.</p>
  
  <p>Thanks</p>