Sequential Numbering

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

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
 
jwrnana said:
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.
Click to expand...

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.
 
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
 
Back
Top