Progess scores for caseworked clients

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I am looking for advice on the best way to implement this in Access 2003.
Although I'm quite familiar with the basics of Access, this is a bit
complicated (I think) and I'd really appreciate some expert advice.

The situation is that I have a table, let's call it 'tblprogress', in which
is stored the details of clients who are being assessed against 7 different
areas on a scale of 1-5. Each client will appear many times in the
tblprogress; they are usually assessed at least once a quarter.

I am basically trying to work devise a query which will enable me to look at
which clients have made progress over time. I will therefore probably want
to look at their first score and their latest score and have the query note
whether the client has remained the same, improved or worsened.

I am not entirely sure about the most efficient way to go about this and, as
a starting point, would appreciate some ideas on the best way forward.
 
You haven't provided any information about your table structure. Some sample
data might also help as well as result after applying your specifications
for "have made progress over time".
 
Apologies. I am still at an early stage in this and haven't even got table
designs finalised. By 'progress' what I mean is that each client will have a
total score based on the 7 different areas. Each time an assessment is
carried out there will be another row in the tblprogress with another total
score. In terms of queries I suppose I can use the min function to get the
first assessment and the max function to get the lastest one. However, is it
then possible to somehow compare the two (total scores) and say whether the
latest score has gone down, up or remained the same?

Please tell me if I am still being too vague and I will endeavour to set out
my question more fully.
 
You need to figure out your tables first. If you normalize your tables, you
shouldn't have an issue querying and reporting your progress.

Each assessment of a single area should create a record in a table. If you
have "7 different areas", this should create 7 different records. You might
want to look at the "At Your Survey" and "Employee Evaluation" samples at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
 
Back
Top