Maybe it is easier to say, that I want the query or report) to say when client number is the same show me the difference in housing scores between AsssessNo 2 and 3, or 3 and 4 etc. then I want to do the same for Medication Scores. Does that make sense?

Im sorry, I was trying to show you the sample data I was working with. The first set of data shows you the results that I want. I am new to this site, please let me know if there is anything else you need.

Here is some sample data. I took all the other assemssment scores out and only left 2 (housing and Medications) which are sub totals of other scores. What I am hoping to be able to see is differnces of scores for each client. Assessment 1 is the original score, so no differnce there, but I want to see if score increased or decreased on each additional assessment. Results I want to see are:
EG Client
...

Hi, I am trying to set up some reports or queries that show the difference between assessment scores. We are trying to set up queries and reports that show difference between scores if certain citeria are met, Eg between a data range, or for certain Programs. Each assessment has an initial assessment (AssessmentID=1 ) and then reassessments AssessmentID 2 or 3 or 4 etc). I guess what I am really looking for is a way to write a query where I can say...