title: Is there a way in MS Access to calculate based on previous record?
body: <p>Like in title is there a way in MS Access to calculate field based on current and previous record?<br />
  Overall i want to migrate my Excel file to Access because of amount of data, but i stuck on &quot;translating&quot; formulas to Access.</p>
  <p>I have a table, log-like data.<br />
  User|Date|Hour<br />
  At the end of the tabel i have few columns with calculation with I want to move to access:<br />
  T1 <code>=IF(U3=U2;(V3+W3)-(V2+W2);&quot;&quot;)</code><br />
  T2 <code>=IFERROR(IF(HOUR(Z3)&gt;=4;&quot;&quot;;Z3);&quot;&quot;)</code><br />
  T3 <code>=IF(AA3=&quot;&quot;;&quot;&quot;;IF((AA3*24)&gt;12;0;AA3))</code></p>
  <p>Screenshot of the actual table. <a href="https://i.stack.imgur.com/9PfYY.png" rel="nofollow noreferrer">Table</a></p>
  <p>Is there a way to do something similar in Access?</p>