Query that searches four different fields for one field?

[metst7]

I'm seeking help that will enable me to create a query that will search four
different fields and place the data in descending order into one field.

 

[Duane Hookom]

Do you have an example of what this might look like? Perhaps show some
sample records and desired output/display?

 

[TedMi]

This sounds like a classic case of non-normalized design. Please provide more
info about your problem domain

 

[metst7]

This sounds like a classic case of non-normalized design. Please provide more
info about your problem domain

There are four different fields for an assessment. They are categorized by
D, i, S, C. The scores range from 1 to 7 in each field. I need to place
these four separate scores from highest to lowest in categories called
PRIMARY, SECONDARY, MODERATE, and LOW. A Primary score is the highest score
in the range of 5, 6, or 7. A Secondary score may equal the Primary score
but is still not lower than 5. A Moderate score is always equal to four. A
Low score is equal to 1, 2, or 3. How can I pull data from D, i, S, and C to
search for the highest score and place it in Primary? One person may have a
7 in the D category as highest while another person can have the highest of 5
in the C column, but the database still needs to recognize it as the highest
score for this person. Each category of Primary, Secondary, Moderate, and
Low needs to pull from D, i, S, and C to basically rank them in descending
order. Is this possible?

 

[Duane Hookom]

I think what TedMi assumed is fairly accurate. Four assessments should
create four records rather than four fields in a single record. Four records
can easily be sorted from highest to lowest.