Question on Sorting within a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rich - 01 Nov 2007 15:10 GMT

Hello,

I have 1 query which is the basis for a datasheet and a report. It seems
that no matter what I specify in the ORDER BY clause, the sort order differs
in the report and datasheet. Same thing results if I ORDER BY more than 1
column. It also seems that if I specify sorting by more than 1 column in
design view, sorting only occurs on the first column. When I switch to SQL
view, both columns do show up in the ORDER BY clause, but still only 1 column
is sorting.

Is there a bug of some sort that pops up when sorting query results?

TIA,
Rich

Reply to this Message

Roger Carlson - 01 Nov 2007 15:19 GMT

A report completely ignores the OrderBy clause of the source query. You'll
have to set the order in the Sorting and Grouping dialog box in the report.

Signature

--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> Hello,
>
[quoted text clipped - 13 lines]
> TIA,
> Rich

Reply to this Message

rich - 01 Nov 2007 15:45 GMT

Thanks Roger.

I found it in the Report properties on the Data tab.

> A report completely ignores the OrderBy clause of the source query. You'll
> have to set the order in the Sorting and Grouping dialog box in the report.
[quoted text clipped - 16 lines]
> > TIA,
> > Rich

Reply to this Message