title: Get ID from name with Access DLookUp function
body: <p>Long story short I need to DLookUp an ID based on the name of a record. In this case I need to get the ID of a city based on it's name. When I try </p>
  
  <pre><code>DLookUp("ID","Cities","Name = London")
  </code></pre>
  
  <p>it says it cant find name "London"</p>
  
  <p>Side Question:
  Can I write queries in Access using pure SQL somehow?</p>
  
  <p>Big thanks for help</p>