How to sort the result of PIVOT? (1 Viewer)

[myuser]

Hello everybody,

I had made a report based on a query last year as bellow, but I don't remember how did I sort the results by "Totally"?

TRANSFORM Count(ID)
SELECT specialist,Count(ID) AS Totally
FROM projects
GROUP BY specialist
PIVOT main_firm;


The results are sorted by Totally:

Specialist totaly A B
-------------------------
Sara 10 6 4
David 7 2 5
Paul 3 2 1

When I run the Query, the results are not sorted, but in the report I see them sorted.

I'd like to create another report similar this one, but I do not know how could I do.


Anybody knows?


Best Regards

 

[Uncle Gizmo]

If you look at the report in design view you will see a panel at the bottom with various options, including sort.

 

[myuser]

If you look at the report in design view you will see a panel at the bottom with various options, including sort.

Thank you, but where is this panel? you mean in footer?

 

[JHB]

Open the report in design view, right click, then choose option "Sorting and Grouping".

 

[myuser]

Thank you so much JHB.
However I dont think I had sorted result via this menu, maybe there is another way too, But really thanks for your help.

Have a nice day

 

[JHB]

If you want to sort in a report then this is the way, because even if you do a sorting in the query, the report doesn't take notice on it. Did you even try to activate it?
Here is a more detail about grouping and sorting in a report:
http://www.functionx.com/access/Lesson25.htm