I have the following problem:
In a report I want to group data by one field /Employee/ and sort grouped data by another field /calculated field =Count([someNumber])/.
But in a "Sorting and Grouping" window when you choose a grouping field it automatically sorts data by same field. Even if I add second field for sorting I can't remove first field sorting.
Any ideas what should I do?
Just to explain: I use adp and SQL server. In the past when I used pure Access I could do a crosstab query that makes all the counts and sorting I needed and then I used to made a report based on that query. But now with SQL server i use simple view and try to make report do all grouping, counting and sorting ...
If i use your example, my report will look like this:
Report is grouped by field "Employee" and it automatically sorts data on this field. So even if i add sorting on "Total" it ignores it because data has already been sorted by Employees.
By the way, I do grouping and sortung using GUI /not in code/ and in build-in "Sorting and group" window it sorts automatically the field that is "Group by".