How do I custom sort records in a report?

S

Sandy

I have been using the following in my query for the report but when the
report displays the data, it's not sorted. How do I custom sort records in a
report?

Expr1: Switch([Month Quoted]="January",1,[Month Quoted]="February",2,[Month
Quoted]="March",3,[Month Quoted]="April",4,[Month Quoted]="May",5,[Month
Quoted]="June",6,[Month Quoted]="July",7,[Month Quoted]="August",8,[Month
Quoted]="September",9,[Month Quoted]="October",10,[Month
Quoted]="November",11,[Month Quoted]="December",12)

Thank you,
 
D

Douglas J. Steele

Reports don't respect the order in the underlying query. You need to use the
Sorting and Grouping dialog in the report designer.
 
C

Chuck

Reports don't respect the order in the underlying query. You need to use the
Sorting and Grouping dialog in the report designer.
Click to expand...

In your report set Expr1 as the first item in sorting and grouping and make it
ascending.

Chuck
--
 
Top