title: Access SQL Query: Get specific field of a previous record looked up by date
body: <p>I am pretty new to Access databases and I am trying to create an inventory database for a gas distribution company with multiple gas stations.</p>
  
  <p>Each station has an inventory of more products/gas types.</p>
  
  <p>The gas stations report their inventory including</p>
  
  <ul>
  <li>TransactionDate</li>
  <li>GallonsSold</li>
  <li>GallonsDelivered</li>
  <li>ActualGallonsInventory</li>
  <li>BookedInventory</li>
  </ul>
  
  <p>The difference between ActualGallonsInventory and BookedInventory is the overage/shortage on gas.</p>
  
  <p>In my query I want to display the stock level (ActualGallonsInventory) of the previous day for the station/gas combination. How can I look up a certain entry of the previous day and display it in my query as a field?</p>
  
  <p>There is only one entry for each station/gas/date combination.</p>