Sequential Numbering

[jwrnana]

I have reports that are pulling from a query. In the query, I have a
field - line item which I have marked ascending, or descending. Any way I
mark it, the report prints out of order. ie -- should read 1, 2, 3,
----------- reads 1, 3, 2, 4 How do I get the report to print
in order?

I apologize if this is a duplicate post, but I could not find my original
post from yesterday on ANY of the newsgroups.

Joy

 

[Rick Brandt]

I have reports that are pulling from a query. In the query, I have a
field - line item which I have marked ascending, or descending. Any way I
mark it, the report prints out of order. ie -- should read 1, 2, 3,
----------- reads 1, 3, 2, 4 How do I get the report to print
in order?

I apologize if this is a duplicate post, but I could not find my original
post from yesterday on ANY of the newsgroups.

Reports generally ignore any sorting that might exist in the Data Source. Use the
Sorting and Grouping tool in the Report's design view to set your sort order.

 

[GreySky]

Rick is correct...

I just wanted to point out that using

TOP 100 PERCENT

in your query will force the query to execute your order
by. Otherwise, MS Access will ignore it in suqueries and,
as in your case, reports.

David