title: Access 2013 - DlookUp
body: <p>I now have tried <code>DLookUp</code>, but I do not get the result I want.</p>
  
  <p>My Situation:  I am creating a database for a cinema. It includes tables named cinemas, movies, sold seats, price.</p>
  
  <p>I have made a form where I can record a new "guest". I can select the ID of the Show and then I see the date and the time. I now have recorded some guests and now there should be less seats free. I want to show that on the same form as the one where I record new guests. I don't get up with the <code>Dlookup</code>.</p>
  
  <p>I have made this query which calculates how many seats are left but I cannot put that into the form.</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
      tbl_Vorstellung.ID_Vorstellung,
      tbl_Kino.Kino,
      Sum([tbl_Kino]![Sitzplätze]-[qry(02)PlätzeVerkauft]![AnzahlvonTicketNummer]) AS Ausdr1
  FROM
      tbl_Kino
      INNER JOIN ([qry(02)PlätzeVerkauft]
      INNER JOIN tbl_Vorstellung
      ON [qry(02)PlätzeVerkauft].ID_Vorstellung = tbl_Vorstellung.ID_Vorstellung)
      ON tbl_Kino.ID_KINO = tbl_Vorstellung.FS_KINO
  GROUP BY
      tbl_Vorstellung.ID_Vorstellung,
      tbl_Kino.Kino;
  </code></pre>