AnsweredAssumed Answered

What is the best way to produce running differences?

Question asked by synergy46 on May 14, 2009
Latest reply on May 22, 2009 by ralvy

Title

What is the best way to produce running differences?

Post

I have a table:  Tests

   TestsID.pk

   PatientID.fk

   DoctorID.fk

   TestName

   Value

    Notes

 

 The input layout is on a portal and it works great.  (See picture below)

 

I have produced a sub-summary report below that also works great.

But, I want to add a field that shows the difference in Values between

succeeding dates.   For example, the June 15, 2002 'diff' field would be to the right of

Value and show 22-5.2=16.8 .  

 

What is the best way to do this?

 

Outcomes