Sorting multiple numeric fields for one record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
Click to expand...

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]
 
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?
 
Back
Top