record order not working

  • Thread starter Thread starter eric
  • Start date Start date
E

eric

I have Access 2000 and I can't get a report to show
records in ascending order by the primary key which is an
integer. I have the report's record source as an SQL
statement on one table (see below). If I run a query
seperately, the order works, but through the report, the
order does not work. It's completely nutty and I'm
frustrated. Any ideas?

SELECT [WO_Data].[WO#], [WO_Data].[Complete?], [WO_Data].
[OpenDate], [WO_Data].[MaterialCosts], [WO_Data].
[LaborCosts], [WO_Data].[OrderedPOCosts], [WO_Data].
[RecdPOCosts], [WO_Data].[WarrWork], [WO_Data].
[CustomerName], [WO_Data].[AssignedTo], [WO_Data].
[Problem] FROM WO_Data WHERE ((([WO_Data].[Complete?])
=No)) ORDER BY [WO_Data].[WO#] ASC;
 
Report order is only reliably set by using the Sorting and Grouping dialog
within the report. The order of records in the query has little or no effect
on the order in the report.
 
Back
Top