Sorting values in reports based on crosstab queries.

[Guest]

I've used a crosstab query to create a report. However, I would like to sort
the values (not the dates). Can I modify my query or report properties to
fix this? Or, do I need to go back to the drawing board? Below is an
example of what I am currently getting.

Cust ID Widgets 9/1/04 9/2/04 9/3/04 9/4/04
43 5 15 50 40
32

What follows, is what I would like to get. (Values in descending order)

Cust ID Widgets 9/2/04 9/3/04 9/4/04 9/1/04
43 5 50 40 32
15

Any ideas?

 

[Guest]

Open the query in design view and change the sort on the field you want to
sort by to Decending with the dropdown.

 

[Guest]

I tried doing that. Howeve, the value cell is the result of a SUM. When I
try to sort, I get the error message "cannot have aggregate function in ORDER
By clause"

jsccorps