Query that searches four different fields for one field?

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.

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

--
Duane Hookom
MS Access MVP


"metst7" wrote in message
...
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.

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

"TedMi" wrote:

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


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?

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.

--
Duane Hookom
MS Access MVP


"metst7" wrote in message
...


"TedMi" wrote:

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


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?