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.

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

Chuck
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top