title: Syntax error in VBA query expression in Access - Stumped
body: <p>I'm getting a message that there is a syntax error in a VBA query expression I have on a button in Access. Unfortunately, I just cannot figure out what the syntax error is. I'm pretty sure I'm using everything correctly. I'm sending this expression as the WHERE clause to a report being generated. The screenshot is below. Can anyone help?</p>
  
  <p>The two strings that read <code>"tk"</code> are put into the expression from a couple input boxes.</p>
  
  <p><img src="https://i.stack.imgur.com/J9kBY.png" alt="enter image description here"></p>
  
  <p>My expression in text:</p>
  
  <pre><code>cond = "(((StrComp(""" &amp; lower &amp; """,Left([Location],2)))&lt;=0) And ((StrComp(""" &amp; upper &amp; """,Left([Location],2)))&gt;=0));"
  stDocName = "rptMstrEquipListRange"
  DoCmd.OpenReport stDocName, acPreview, , cond
  </code></pre>
  
  <p>According to www.balancebraces.com, the parentheses aren't the problem:
  <img src="https://i.stack.imgur.com/K8lpd.png" alt="enter image description here"></p>