Access 2000/2003: Report and query sort order

  • Thread starter Thread starter Anno v. Heimburg
  • Start date Start date
A

Anno v. Heimburg

Hi Group!

I have a strange problem here. In a report, I am displing results of some
earlier computation by calender week, i.e.

CW data
50 akdj
51 adl
52 bww
1 98
2 vkn
3 al3

etc.

As you can see, this might span two years (first rows are from 2003, later
ones from 2004), and I want it to be sorted in that order.

Now, the rows in the report's ControlSource query are sorted correctly, but
the report suddenly decides that it has to re-sort everything as if the CW
field was a string, i.e.

1
10
11
..
..
..
50
51
52
..
..
..

which is not what I want. It should just take the order of the query and use
that unmodified.

The "Order By"-Property is turned off in the report, and there are no
entries in "Sorting And Grouping" - why does the report sort anyway?

Thanks in advance,

Anno.
 
The sort order of the query used as RecordSource is _immaterial_. Sorting
and grouping in Reports is done with the Report's Sorting and Grouping
Dialog. In Design View, click the upperleftmost little box, then right-click
and choose "Sorting and Grouping".

You are probably going to have to include a year value and sort on both year
and calendar week to do what you want. If you want it sorted as numbers,
then ensure that is a numeric field. (The fields on which you sort and group
do not necessarily have to be visible on the report.)

Larry Linson
Microsoft Access MVP
 
Back
Top