Reports output

J

JerryJay

I have a report which contains weights for individuals and the date the
weight was taken. The output looks like this:

NAME IdealWt WtDate WtAmt WtChng PerCentChg
John Smith 104-127 100.0999985
01/08/05 104.70 4.599998474 4.6%
02/08/05 103.80 3.700004578 3.7%
03/08/05 99.60 -0.5 -0.5%

SELECT SU.LNAME, SU.FNAME, TblWts.WtDate, SU.MName, SU.IdealWt, SU.STATUS,
SU.SOCSEC, TblWts.SocSec2, TblWts.WtAmt, [WtAmt]-[StartWt] AS WtChng,
[WtChng]/[WTAmt] AS PerCentChg, SU.StartWt
FROM SU INNER JOIN TblWts ON SU.SOCSEC = TblWts.SocSec2
WHERE (((SU.STATUS)<>"D"))
ORDER BY SU.LNAME, SU.FNAME, TblWts.WtDate
WITH OWNERACCESS OPTION;

The problem I have is that i need to change the calculation so that I am
calcualting a weight change and percentage from the previous weight and not
the starting weight. Any suggestions would be appreciated.

The query I created is:
 
Top