Sorting multiple numeric fields for one record

[blanton]

In a db built for surveys, can I sort (rank) multiple numeric fields for one
record? Each record has 24 fields ranking students on performance. I want
to be able to rank the responses to show at which of the 24 areas the
students are strongest and at which they are weakest.

 

[KARL DEWEY]

Sounds like your table structure is a 'spreadsheet' and not a relational
database at all. Post your table fields and datatype with some sample data.
Also show what you waould like the results to look like.

 

[John W. Vinson]

In a db built for surveys, can I sort (rank) multiple numeric fields for one
record? Each record has 24 fields ranking students on performance. I want
to be able to rank the responses to show at which of the 24 areas the
students are strongest and at which they are weakest.

If you had a stack of sheets of paper, each with 24 scores on it, what order
would you sort the stack to get your desired result?

I think your database design may need reconsideration. What if you decide you
need to add 3 more rating criteria? Do you redesign your table, all your
queries, all your forms, all your reports!?

John W. Vinson [MVP]

 

[blanton]

I'd sort by name, since that is what gives the 24 other fields relevance.
It's a pretty static survey tool that Access allows me to manipulate the data
and present more easily than Excel. How would you re-configure?