Access97 Reports Ignore ORDER in Query?

  • Thread starter Thread starter Jonathan Scott via AccessMonster.com
  • Start date Start date
J

Jonathan Scott via AccessMonster.com

I have a report which I am trying to force to display records in a certain
order. However, instead of the order I give in the query statement, it
imposes an order on the primary key of the table. I am not even selecting out
the pk, but it effects the order nonetheless.

Is there a way I can force reports to pay attention to the ORDER I explicitly
state in my SQL statement? Or am I forced to copy it to a temp table just to
get my order?

Jonathan Scott
 
Jonathan said:
I have a report which I am trying to force to display records in a certain
order. However, instead of the order I give in the query statement, it
imposes an order on the primary key of the table. I am not even selecting out
the pk, but it effects the order nonetheless.

Is there a way I can force reports to pay attention to the ORDER I explicitly
state in my SQL statement? Or am I forced to copy it to a temp table just to
get my order?
Click to expand...


The query's sort order only has an effect in the most
trivial reports.

Set the report's sorting in the Sorting and Grouping window
(View menu).
 
Thanks for the help. Yes, it turns out my sort setting was not correct there.
After playing with it a bit, I understand the effect that setting has, and
what the order of the specified columns mean.

Thanks again!
Jonathan Scott
 
Back
Top