I can't get this report to display the records sorted

[Lateral]

Hi guys,

I have a report that uses the following query:

SELECT Parts.*, [PartsSupplierWSP]*[SOH] AS WSPUSD, [Wholesale]*[SOH] AS WSPAUD, Parts.Inactive, [UnitPrice]*[SOH] AS SaleAUD, Parts.Reorder_Level, Parts.PartName FROM Parts WHERE (((Parts.Inactive)=No) AND ((Parts.Reorder_Level)<>0)) ORDER BY Parts.PartName;

When I run the query in the query designer, it sorts the records correctly.

When I run the report, the records are not displayed in the sort order (by Parts.Partname). I have tried everything and it's driving me nuts...what am I missing here???

Thanks for your help.

Cheers
Greg

 

[stopher]

Have you tried using the sort functionality in the report editor. Generally I would not rely on the query to do the sorting. Make the report do the sorting.

 

[Lateral]

Hi Stopher

I have tried the "Order By On Load" option without success...is this what you mean when you say "Have you tried using the sort functionality in the report editor"?

 

[Lateral]

I just figured it out!!!!

I didn't notice that the I have the report group/sort option set at the bottom of the screen and it was not sorting on PartName.....thanks for making me look again and finding it!!!

Cheers