Report Sorting

[bphoward1]

I have an issue sorting the results on my Access 2010 Report. Here are the details:

- Report Record Source = "Portfolio Ranking"
- Portfolio Ranking is the name of a query
- The query includes a calculated field called "Impact Score"
- FYI: this is a web database (not sure if that limits what I can do)

I want to sort the report on the Impact Score column. However, when I view the query calculation for Impact Score, the "Sort" field says "(not sorted)" and it's greyed out, so I can't select Descending as desired.

Is there another way to achieve the desired sort?

Thanks for any help!

 

[pbaldy]

I haven't needed a web database, but typically report sorting is done in Grouping and Sorting, on the ribbon with the report in design view. Are you seeing that option?

 

[bphoward1]

Thanks for the tip, pbaldy! Being a web database, I can't open forms in design view, but I was able to find the "Group & Sort" button on the ribbon (under the Design tab). I'm all set now.

 

[pbaldy]

Happy to help!