record order not working

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

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Order records in a report 1
Link Tables 5
How to display records in ascending order on a report 1
total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi 2
Subreport not prt in sort order defined 0
assign record source 5
mailing labels - square box at end of first line in report 8
sort order in report detail section 2

Top