assign a descriptor to scores from many tables

[neuropsychresearch]

Hello everyone.

I have a series of table with scores in them that are from many different types of tests. The test scores are stored in many separate tables. I'd like to run a query that classifies or categorizes each score from a table that i have. The table has the lookups that apply. So, for example, some of my scores are T scores (with a mean of 50 and SD of 10), while other tables have the inputted data as a Standard Score (mean = 100, SD = 15).

I'd like to write a query that takes each of these values and assigns a descriptor to each score (an IQ of 110 is high average, an IQ of T=40 is low average).

The table has T scores, z scores, standard scores, and a descriptor.
'
Does anyone know how to write a query that could assign these various scores to the appropriate descriptor?

thanks


Neuropsych

[June7]

Sounds like a rather long nested IIf() or Switch() expression.

Possibly need a conversion table.

Provide sample data.

[neuropsychresearch]

[QUOTE=June7;388965]Sounds like a rather long nested IIf() or Switch() expression.

Possibly need a conversion table.

The table that has T scores, z scores, and percentiles etc in it also has the descriptors in it. This is the conversion table. So I have one of those. Let's call the conversion table "ScoreConversion". For example, for a T score = 40, and z of -.67, scaled score of 8, and standard score of 85, all of these would be 'low average'. tblScoreConversion has all of these values in it already. So tblScoreConversion has 5 or so columns, with one of them being the matching descriptor for each magnitude of the four types of scores (Z, T, Standard, percentile, scaled score).

Sample data:

Table 1: IQ standard score = 100. (should be 'average')
Table 2: Trails test T score is 40. (should be classified as 'low average')
Table 3: IQ standard score = 120 (should be classified as 'superior')
Table 4: memory z score = 0. (should be classified as 'average')
Table 5: processing speed scaled score = 11 (should be 'average')

So, I have a complex form that enables data entry for all of these scores.

Once data entry is complete, I would like to run a query so that I can output the raw scores (and the T score, z score, Standard scores, etc) and then, for each score, ALSO include the descriptor (low average, superior, etc)

Make sense?