Question on Sorting within a query

[rich]

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

 

[Roger Carlson]

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.

--
--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

 

[rich]

Thanks Roger.

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