Importance Ranking in Table

[peggy]

I have a table in my staff survey that requires employees to rank the importance of 10 different areas with 1 being the most important and 10 being the least important. I thought it would be easy to report the results by consulting Access Help but haven't been successful. And now I'm looking for a handout. :)
Thank you.
p

[OBP]

Hello, I am not sure what you are trying to achieve with the Ranking.
Do you want to average the scores and then put them in order?
If so this is done using queries, it can certainly be done using 2 queries and may even be able to be done using 1 query.
If you would like to post an example of the "data structure" and some typical values I will see if I can construct something for you,
obviously it would be easier if I had a copy of the actual data.

[peggy]

Hi,
I've attached my access table as an excel file. I want to total and rank order of importance (with the lowest number reflecting the most importance). I can do it in excel of course but cannot seem to create the expression I need to report in access.
Thanks
peggy

[OBP]

peggy, I am sorry, but I can't open the Excel workbook, can you post it again or a zipped copy of the database please?

Ok I have managed to open it now, I will get back to you later on a solution for 1 category to see if that is what you want.

[OBP]

peggy, I think that the reason that you can't get a query to do what you want is because the data structure in your Excel spreadsheet is not correct for Access. This is because I assume that you wish to sort by the Headings "Training Opportunities", "High Wages" etc.
The problem is that Access makes these the field names in the table and as far as I know you can't sort by the field names only the data.
So I wrote some VB code that takes your Excel data and puts it in the form that Access tables would want and created a table using that.
I then created a simple "Group by" query that Groups by category ("Training Opportunities", "High Wages" etc) and sorts by total score achieved.
I have attached a copy of the database to see if that is what you wanted it to do.