title: Get previous calculated value in access report
body: <p>I have a report that calculates several results from a table, Is there any way to get the previous value from a calculated camp inside a report?</p>
  
  <p>Let's say I have a Text box A which is inside a "group" in a report, and I need to calculate another result that needs the previous value of A, example:</p>
  
  <pre><code>FieldA(1) = TableValue1  FieldB = null(cos FieldA  doesn't have "previous" values") / 54 * 152
  
  FieldA(2) = TableValue2  FieldB = FieldA(1) / 54 * 152
  FieldA(3) = TableValue3  FieldB = FieldA(2) / 54 * 152
  </code></pre>
  
  <p>Or is it better to reach this using sql?</p>