"Order by" not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem that I think I've had before. Perhaps there's a bug in
Access; I'm using Access 2000.

In the report properties up near the top I have "Order by on?" set to YES
and the "Order by" property set to the field I want. What I find is that
this changes nothing - specifying which field to order by does not result in
the report being ordered by anything.

Am I doing something wrong or is this the fault of Access?

Thanks much for any help.

David
 
I have a problem that I think I've had before. Perhaps there's a bug in
Access; I'm using Access 2000.

In the report properties up near the top I have "Order by on?" set to YES
and the "Order by" property set to the field I want. What I find is that
this changes nothing - specifying which field to order by does not result in
the report being ordered by anything.

Am I doing something wrong or is this the fault of Access?

Thanks much for any help.

David
Click to expand...

David,
The place to set OrderBy (in a report) is in the Report's Sorting and
Grouping dialog.

Click View + Sorting and Grouping

If you already have another Sort order selected in the Sorting and
Grouping box, that will over ride anything you place elsewhere. One way
to sort on your wanted field (in addition to the other fields already
selected) is to add that field to the Sorting and Grouping box and then
move it to the top of the list if that is the first order of sort
wanted.

If you have nothing in the Sorting and Grouping dialog, then you can use
[SomeField]
in the Report's OrderBy line, and set OrderByOn to Yes.

Now the [SomeField] will be sorted.
Use [SomeField] DESC
if you wish to sort descending.

But use the Sorting and Grouping dialog if you can.
 
Fred,

Thanks for your help. Indeed, I'm familiar with the Sorting & Grouping box
but I don't know why I didn't resort to it.

I'll use that. Thanks again.

David

fredg said:
I have a problem that I think I've had before. Perhaps there's a bug in
Access; I'm using Access 2000.

In the report properties up near the top I have "Order by on?" set to YES
and the "Order by" property set to the field I want. What I find is that
this changes nothing - specifying which field to order by does not result in
the report being ordered by anything.

Am I doing something wrong or is this the fault of Access?

Thanks much for any help.

David
Click to expand...

David,
The place to set OrderBy (in a report) is in the Report's Sorting and
Grouping dialog.

Click View + Sorting and Grouping

If you already have another Sort order selected in the Sorting and
Grouping box, that will over ride anything you place elsewhere. One way
to sort on your wanted field (in addition to the other fields already
selected) is to add that field to the Sorting and Grouping box and then
move it to the top of the list if that is the first order of sort
wanted.

If you have nothing in the Sorting and Grouping dialog, then you can use
[SomeField]
in the Report's OrderBy line, and set OrderByOn to Yes.

Now the [SomeField] will be sorted.
Use [SomeField] DESC
if you wish to sort descending.

But use the Sorting and Grouping dialog if you can.
Click to expand...
 
Back
Top