title: Ms Access query previous day's date
body: <p>How to bulid a query in Ms Access to include the day before amounts as an opening balance. So on running the query i enter 3/10/18 in the WorkDay parameter box and records for 3/10/18 and 2/10/18 is shown. The Table is setup as follows:</p>
  
  <p>WorkDay....TranactionID....Amount</p>
  
  <p>2/10/18......Opening........1000</p>
  
  <p>2/10/18......Credit.........500</p>
  
  <p>2/10/18.......Debit.........300</p>
  
  <p>3/10/18.......Credit........700</p>
  
  <p>3/10/18.......Debit.........200</p>
  
  <p>So if I run the query for 3/10/18 it should return </p>
  
  <p>WorkDay....TranactionID....Amount</p>
  
  <p>2/10/18......[Expr].........800</p>
  
  <p>3/10/18.......Credit........700</p>
  
  <p>3/10/18.......Debit.........200</p>